Hi
So I am int he middle of writing a program in VBA Macro that would loop through all the Excel files in a directory and change the footer. HOwever the code that I have now

.LeftFooter = "&[Date]"
.CenterFooter = "&[Path]&[File]"
.RightFooter = "&[Page]of &[Pages]"

VB i percieving this code (the code that appears in the View Header/Footer Window) As a string.. so its putting the word date on the left hand of the footer. Any Suggestions?