2003->2007"unable to set the Left header property of the PageSetup

[Guest]

hi,
i have a macro with the following code:
With ActiveSheet.PageSetup
.LeftHeader = "&D"
the macro is ok in 2003, when i try to run it in 2007 i got the following
message:
"unable to set the Left header property of the PageSetup class"
could you please advice, i need the code to work in both environments.
thanks,

 

[Gary Keramidas]

this works in both versions for me
With ws3.PageSetup
.LeftHeader = "&G"
end with

which shows a picture
and

..LeftHeader = "&D"
shows the date in both versions for me, too.

post the code

 

[Guest]

maybe the code is ok, but in my 2007 i miss the dll or any other
configuration. please advice ...which dll i should look for...