-
Excel FOoter codes
Hi,
I got a looping program to work that essentially loops through the files in a directory and changes the footers etc...The only problem i am having is encoding the footer... eg i have to put filename and path in the center. so I write
.CenterFooter = "&[File]&[Path]" but it perceives it to be text, however If
.CenterFooter = "&F" It puts its true filename without the path...
any suggestions?
-
Re: Excel FOoter codes
Too easy ... just record a macro to do what you want and then look at it in the VBA window: .CenterFooter = "&Z&F"