VBA code to insert pictures in a column of cells
I have a folder of 99 pictures with filenames: image01.jpg, image02.jpg up
to image99.jpg. All of these images are small, and the same size.
I want to insert them (in order) in a column of cells (A1, A2, to A99) using
VBA. The images should be embedded, not linked. Resizing cells to the right
size would be a nice extra, but not necessary - it's easy in this case to
resize manually. Thanks for looking at my question - and I hope to hear some
...Exchange installation question
We are considering going to Exchange from Groupwise. We currently have
AD on a Windows 2000 infrastructure. My question is if we installed
Exchange 2003 on windows 2000, can anyone share their thoughts on later
upgrading the os to 2003? It would probably make sense to upgrade the
network now, then install exchange, but we're in a crunch at the moment
and need to get this e-mail project going.
Starting afresh with a new OS install is always preferable, but not always
possible. Can upgrade OS later if that's the case, the only issue is
unavailability of cer...Formatting Question 01-25-08
I'm new to coding so please forgive my ignorance.
I'm needing to change a font color for the field [Employee Name] and a short
date format for the field [Exception Date] which appears in the message body
of an email via DoCmd.SendObject. I included a section of the code below.
If you can help I would appreciate it. Many thanks!
DLookup("[Employee Name]", "qryCommunication") & " " & DLookup("[Today's
This will be pretty tricky. You would need to format the message body as
HTML or...OWA question about URLs in email messages
We are new to OWA and I have noticed an issue with links (URLs)
contained within email messages. If I click on a URL contained in a
message, the login pops up - as though I had logged off. If I try to
open the link in a new window, the same thing happens. If I open
another browser window before I login to OWA, I can copy and paste the
link successfully. My sense is that I have probably missed something
along the way in my IIS configuration or this issue is caused by the
secure connection I am using to access OWA. Our users are mere
mortals, though and are likely to be perplexed by this...
W20...Newbie Questions ?
Thanks for previous help; really appreciate it.
Two questions, please:
a. Copied a column of frequencies from a radio database into Excel 2007
Copied fine, but the numbers in the Excel column have a * preceding each
What does this signify, or it just an artifact from the copying ?
b. I have numbers in column C that are derived by dividing each number in
column B by a constant.
I would now like to "save" what I have just generated in C, but would like
to eliminate all the numbers in B
As soon as I eliminate column B, column C is naturally no longer correct as...Formula Question #3
I have a spreadsheet that I'm working on that tracks employee
attendance. A sample is included below:
A B C D
1 Name 06/07/04 Final Warning Attendance
2 Name 08/21/03 Warning Tardy
3 Name 12/04/02 Warning Attendance
4 Name 09/16/02 Counsel Tardy
5 Name 08/05/02 Counsel Attendance
Is there a formula that will tell me how many instances an employee was
on an Attendance or Tardy disciplinary step of Final Warning, Warning ...Fill column question
I have a problem that I have seen similar answers for, but they are not
specific enough to my problem.
I have gotten close by looking at other examples, but I'm not having much
luck modifying the code.
What I would like to do is to create a macro that populates a certain column
(J) from J2 to the last row of data. For example, sometimes the range will be
J2:J200 or J2:J333 - it's never constant.
My macro so far just fills one cell (J2) and selects it so that the corner
handle is visible - the user just has to grab it and drag down the column.
It woul...VBA Passwords
I passwod protected by VBA modules so that no one could see them. But
have just come back from holidays forgetten my passwords and now
can't see them!
Any ideas how I can recover the
Message posted from http://www.ExcelForum.com
If you are using a newer version of excel that excel 97, then you will
either have to remember it or use a commercial password cracking program. If
you are using Excel 97 there is a free program called vbakey.exe that will
tell you your vba password.
Outgoing mail is certified Virus Free.
Checked ...array in VBA
A few days ago I saw an answer to a post that showed the VBA equivalent of
using an array worksheet formula with ctrl+shift+enter. I forgot to copy
that answer for later use, now I can't find it anymore. Anybody who knows
what I mean? If so, please tell me where to find the post.
"Jack Sons" <firstname.lastname@example.org> wrote in message
> Hi all,
> A few days ago I saw an answer to a post that showed the VBA equiva...comment box pop ups
dear kind people who know excel!
I have a sheet where in column A I have the name of a compnay. In column D
(which is hidden) I have some descriptive info. Is it possible for the info
in column D to come up in a comment box (or any otehr pop up box) when I
hover over a cell in column A? The sheet is being continually sorted so it
needs to be quite robust.
thanks in advance
Rather excel illiterate person!
The only thing that I know that shows up when you hover the mouse over the cell
is a comment.
So if you added the text in column D to the comment in column A, then it might
...MS2004 Feature Question
Under tools, options, investments tab in 2004 Dlx, there is a check box
"Require a transfer account for each investment transaction". What is the
pros and cons of using this? I couldn't find any help on it.
Pro: it will suggest best practices for entering these kinds of
transactions--accounting for where the cash comes from or goes to--if you
don't already follow them. I may be wrong, but I don't think it will
actually REQUIRE them, only it will nag if you don't have one and will allow
you to continue if you really want to. Most of these choices, l...Question about format of reply and format of message
I have two questions about OL2003:
1. Word is set as default editor. In replying message, sometimes I will get
extra lines on hitting Enter. It makes more space between paragraphs. Is
there any way to insert one line with one Enter?
2. I'd like to have special effect in replying text message sometimes, such
as change color of font, but it cannot be done unless changing the message
format to be rich text or HTML. If I uncheck Word as default editor, there
is an option in menu. What is it about with Word as editor?
1 - Check the paragraph spacing settings e...excel vba
I have set up my sheet to protect using a password name login which the
runs the macros. It is set up so that the sheet's cells cannot b
edited, but the person can copy/paste the info onto another sheet.
This is a problem because there are hidden cells which contai
sensitive data. Any ideas
Message posted from http://www.ExcelForum.com
Hi, just a comment that i just found out, check out this
link that I was refered too. That password that you
setup doesn't do squat when you have access to this...
I was mad when I saw this, when mean...Any sync app showing diffs in comments/text fields?
Hi all -
I am looking for a synchronization app for Outlook 2003 which will
allow me to sync data between my laptop and desktop. I know there are
several that do this in some way, but they just allow selection of one
duplicate over another. I tend to update contact notes in the large
field underneath the IM field on the main screen, and I would love for
an app to alert me on duplicate contacts and say, this text is
different, do you want to update or merge the information?
Is there anything that will do this? TIA for your help!
vettejock99 <email@example.com> wrote:
> I am look...Index, Match, Min and Max question
I'm trying to retrieve a date (in column A) that corresponds with a
Min and Max amount (in columns B:D). Basically I need to know when my
amounts hit their Highs and Lows. Can someone help me with this
Dates in column A; values in B
Returns the date corresponding the max value in B
Is this what was needed?
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
<firstname.lastname@example.org> wrote in message
>...Any method available to insert pic into comment box??
Any method available to insert picture into comment box?
or just wishful hoping?
There are instructions here:
> Any method available to insert picture into comment box?
> or just wishful hoping?
Excel FAQ, Tips & Book List
I'm starting a project that will display a lots of data on CTreeCtrl.
I want to allow the user to see the same data in different views.
Ideally I would want to have a one CTreeCtrl with all the data (number
of branches) and when I need to show just a subset of it I would want
to create a new CTreeCtrl. However I would want all the Items in the
second Tree to point to the ones that reside in the main TreeCtrl.
Each of the items will have pointer to correspoinding underlying
object and I would want to share those as well.
I know that I can pass the root of the HTREEIETM and then reconstruc...HELP WITH VBA
I am trying to finish writing some simple program.
My problem is that when I try and change the arguement from SELECTION
CHANGE to CHANGE, it doesn't work. Can someone help?
Private Sub Worksheet_Change(ByVal Target As Range)
If Worksheets("Sheet3").Range("B3").Value = 2 Then
My second problem is that I would like my data rather than appearing in
a cell, appear in a TEXT BOX. What do I do?
Copying your exact same post from 3 days ago word...Simple CDC question
I'm just trying to draw 4 lines in a picture control (CStatic, right?).
Honestly I do not know what I'm doing re: CDC but I had to try. This is
what I wrote:
CDC* pDC = m_Picture.GetDC();
CGdiObject *pOldBrush = pDC->SelectStockObject(WHITE_PEN);
PictureSize = pDC->GetWindowExt();
int W = PictureSize.cx;
int H = PictureSize.cy;
int n = 4;
pDC->LineTo(W - n, n);
pDC->LineTo(W - n, H - n);
pDC->LineTo(n, H - n);
In a column, I have a series of numbers in this format: 00700*, 01200*,
127000*. This data comes from an outside source, and I need the cells to
read 007, 012, 127, without the final 000*.
I can't seem to make this happen with Find/Replace, finding 000* and
replacing with nothing (to remove the final 000*, as I can do in Word).
Any thoughts how I might accomplish this?
Kind regards to all.
have you tried text to columns? use fixed width.
>In a column, I have a series of numbers in this format:
>127000*. This dat...VBA
Ok, all you expert Excel users may think this is dumb.....but what is VBA?
And what do you use it for? I looked around and can't figure a thing out.
Visual Basic for applications. Used to write macros/programs. As a
"Kim" <Kim@discussions.microsoft.com> schrieb im Newsbeitrag
> Ok, all you expert Excel users may think this is dumb.....but what is
> And what do you use it for? ...Auto Page Numbering Question
I have a 12 page pricelist. Recently we made changes to the last 4
pages of this sheet. I am not getting ready to have the last 4 pages
printed and sent to my customers so that they can simply replace the
last 4 pages, leaving the first 8 in tact.
I copied the last 4 pages into a new book, and need the page numbers
to read 9 of 12, 10 of 12 ect. However, because the pages are in a new
book I can only figure out how to have it say 1 of 4, 2 of 4 and so
Basically, I need to change the footer to read 9 of 12, 10 of 12, 11
of 12 and 12 of 12, but this is only a 4 page sheet.
...VBA function changing name
OK, here's a strange one - well strange to me anyway. I've declared a
function in a module using mixed case:
Function TMDE_Category (FormName As Form)
The function is called by the VBA code behind two different forms. I noticed
the other day that it appeared in the module as
Function tmde_category(FormName As Form)
Obviously, this isn't preventing the database application from running, but
I can't figure out why it changed. I changed it back to the mixed case
declaration, saved the module, exited the app, reopened it and looked. The
function had changed back t...Connection Filtering Question
If a connection filter is set up on Exchange 2003 to apply RBLs, does the
filter bounce the message and add the connection filter block message?
Or does it only reply with the connection filter block message?
This is not clear to me in the Exchange Help.
Not sure if this is what you are after, but...
In trying a direct connection to the SMTP virtual server via Outlook
Express, I find that the SMTP transaction is rejected with a 550 5.7.1. The
Outlook Express send/receive window does display the custom error message if
one is configured. The message never leaves the outbox.
&...Serious error during VBA event
We've added VBA code to several windows. Now, all of a sudden, we're getting
this error message, "A serious error occured during a VBA event", for
non-admin users. This is a Citrix environment and we do not get the error
when we log onto Citrix as an administrator.
We found knowledgebase article # 929612 which tells us to give full control
to four registry keys for all users. We tried this but we're still getting