View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JacMar JacMar is offline
external usenet poster
 
Posts: 12
Default Importing an image in VBA

Thanks Alan:

The difficulty is not to print the header only on the first page, it is
related to the fact that I will have a PICTURE as a Header. I am writing a
macro, and I have taken care of the problem of not printing the headers on
every page. It is relatively easy to print different headers and footers on
different pages, using VBA. I also know how to print a picture as a header.
But the reference to that picture is of the form : "C:\. . . .jpg". This
means that if I move the Excel workbook, with the VBA code, to another
computer, it does not find the picture, unless I make sure to copy it in the
required location on the new computer. I want to have the picture as part of
the VBA code, if that is possible.

"Alan" wrote:

Unlike Word, Excel headers are placed on every sheet. This link might help:

http://www.mcgimpsey.com/excel/subs/firstfooter.html

Regards,

Alan

"JacMar" wrote in message
...
Excel 2002. I need to insert a picture (logo) into a header, only on the
first page of a printout. At the present time I am using in my VBA code a
file reference for the picture, "c:\picture.jpg", for example. The
problem
is that when I transport the program on to another computer, the reference
is
no longer valid. I know I can paste the picture onto a sheet, but how do
I
then bring it back into a HEADER, for just one page? or is there another
way
to do this?
Thanks in advance.