I am trying to set the footer on the first page of an Excel spreadsheet through VBA (in Access 2007.) I have set the DifferentFirstP ageHeaderFooter property to true, and header and footer for everything except the first page is correct.
It seems like what I need to do is set .Pages(1).Cente rFooter = "foobar", but I am unclear as to how to get to the pages collection in the first place.
The example text from the msdn excel reference says to go through ActiveWindow.Pa nes(1).Pages, but when I try that I get a run time error 438: object does not support this property or method.
Anyone have advice?
It seems like what I need to do is set .Pages(1).Cente rFooter = "foobar", but I am unclear as to how to get to the pages collection in the first place.
The example text from the msdn excel reference says to go through ActiveWindow.Pa nes(1).Pages, but when I try that I get a run time error 438: object does not support this property or method.
Anyone have advice?