Pictures in Footers (again!)

  • Thread starter Thread starter jayray
  • Start date Start date
J

jayray

I have a logo in .bmp format and I've been able to insert it into a
footer in a model I have. Once it's inserted, I can send out the file
to others, even though technically the file path to that logo in the
format is a subdirectory in my computer. The logo is now embedded in
the model. I'm using Excel 2003.

My problem is this: As part of the printing sequence, I've set it so
that the model inserts a new worksheet, and then the ranges that I
want to print are copied onto this new worksheet. (This has to do with
multiple ranges set by a macro to different scenario settings and
wanting up to 154 reports all to come out as one print job.) The
problem is that when the model is used by other users, as the macro
formats each new worksheet for the printing, it gets stuck with trying
to find the logo, the master of which is of course on my machine, not
of their machine.

Any ideas of how I can put insert a bmp footer on the fly in Excel? Do
I have to send out the bmp file as a separate file with the model?

Thanks for any ideas.
 
You only inserted a link to the bmp file instead of inseting the entirre
picture. What code did you use to put the bmp file into the excel file? I
inserted picture in the footer manually and I think the actual picture was
put in the file.
 
I would send the picture along with the workbook and tell the users to make sure
that both files are in the same folder.

An alternative would be to create a worksheet with the header/footers the way
you want.

Then copy that "template" worksheet and use that to print.

Actually, I think I wouldn't send the .bmp file. I'd do the second.
 
The code I used is the standard one:

With ActiveSheet.PageSetup
.CenterFooter = "&P"
.RightFooter = "&D &T"
.LeftFooter = "&G"
.LeftFooterPicture.Filename = _
"C:\Documents and Settings\libi\My Documents\MetLife\Source
Files\Logo.bmp"
.RightMargin = Application.InchesToPoints(0.3)
.TopMargin = Application.InchesToPoints(0.8)
etc....

How do you insert a bmp picture manually into the footer? I tried copy
and paste, but it doesn't seem to work.
 
I would go with Dave Pertson suggestions. To add a picture manual to a
header or footer you need to use the icon when you view the header or footer.
It is the same strip of icons that has the date and page number. The last
two icons are adding a picture and formating a picture.
 
Back
Top