LeftFooterPicture instruction does not appear to work

[Guest]

Does anyone have any idea why the following command does NOT work when placed
in a macro:

ActiveSheet.PageSetup.LeftFooterPicture.Filename = _
"[filename]"

Where [filename] is the full name including path of a picture file whose
existence I have verified.

Any info would be appreciated.

 

[KL]

I have found the sample code in MSDN
(http://msdn.microsoft.com/library/d...en-us/vbaxl10/html/xlproLeftFooterPicture.asp)
and it won't work for me either. Maybe it is the Office vesion issue: I use
Office 2000 (XL 9) and the above address (.../vbaxl10/...) suggests that the
code is applicable to XL 10. There seems to be no explicit indication of
that though.

my 2 cents.
KL

 

[Guest]

Thanks KL for the reference. I note that at the bottom of that code, the
follwoing appears:

' Enable the image to show up in the left footer.
ActiveSheet.PageSetup.LeftFooter = "&G"

Note It is required that "&G" is a part of the LeftFooter property string
in order for the image to show up in the left footer.

I am going to add this to see if this resolves the problem, and will post
accordingly.

I have found the sample code in MSDN
(http://msdn.microsoft.com/library/d...en-us/vbaxl10/html/xlproLeftFooterPicture.asp)
and it won't work for me either. Maybe it is the Office vesion issue: I use
Office 2000 (XL 9) and the above address (.../vbaxl10/...) suggests that the
code is applicable to XL 10. There seems to be no explicit indication of
that though.

my 2 cents.
KL

Does anyone have any idea why the following command does NOT work when
placed
in a macro:

ActiveSheet.PageSetup.LeftFooterPicture.Filename = _
"[filename]"

Where [filename] is the full name including path of a picture file whose
existence I have verified.

Any info would be appreciated.

 

[Guest]

Facinating:

As per KLs post, the code in the MSDN library works but ONLY if you make
sure (per instructions) to add:

' Enable the image to show up in the left footer.
ActiveSheet.PageSetup.LeftFooter = "&G"

or

' Enable the image to show up in the right footer.
ActiveSheet.PageSetup.RightFooter = "&G"

Of course!

I have found the sample code in MSDN
(http://msdn.microsoft.com/library/d...en-us/vbaxl10/html/xlproLeftFooterPicture.asp)
and it won't work for me either. Maybe it is the Office vesion issue: I use
Office 2000 (XL 9) and the above address (.../vbaxl10/...) suggests that the
code is applicable to XL 10. There seems to be no explicit indication of
that though.

my 2 cents.
KL

Does anyone have any idea why the following command does NOT work when
placed
in a macro:

ActiveSheet.PageSetup.LeftFooterPicture.Filename = _
"[filename]"

Where [filename] is the full name including path of a picture file whose
existence I have verified.

Any info would be appreciated.

 

[Tom Ogilvy]

xl2000 doesn't support graphics in footers.

--
Regards,
Tom Ogilvy

I have found the sample code in MSDN
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaxl10/ht
ml/xlproLeftFooterPicture.asp)
and it won't work for me either. Maybe it is the Office vesion issue: I use
Office 2000 (XL 9) and the above address (.../vbaxl10/...) suggests that the
code is applicable to XL 10. There seems to be no explicit indication of
that though.

my 2 cents.
KL

Does anyone have any idea why the following command does NOT work when
placed
in a macro:

ActiveSheet.PageSetup.LeftFooterPicture.Filename = _
"[filename]"

Where [filename] is the full name including path of a picture file whose
existence I have verified.

Any info would be appreciated.