Excel FOoter codes

[bs272]

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?

[Webtest]

Too easy ... just record a macro to do what you want and then look at it in the VBA window: .CenterFooter = "&Z&F"