Excel VB - Formatting codes for headers/footers?

Question

In VB, you can put filenames, tab names, time & date, etc. in headers and footers using formatting codes (&F for filename, &A for tab name, etc.).

Is there a code for the file path, or is there some other way to insert the path? I have 2003.

My code looks like this, and I'd like to also include the path before the filename (&F):

With ActiveSheet.PageSetup
.LeftFooter = "&F - &A"
.CenterFooter = "&P"
.RightFooter = "&D, &T"
End With

computer guy, thanks, but when you do it "manually" through view headers/footers, it shows [Path], which doesn't work as a format code in VB.

Answer 1

If you want to include the full pathname including the filename at the end do it like so:

.RightFooter = "&Z&F"

If you want just the path without the filename at the end like you are giving the directory then do it like so:

.LeftHeader = "&Z"

It sounds like you want to do the first of my two examples.

Answer 2

yes, if you view headers / footers, you will see the custom header / footer, try those. if you do not see what you are looking for, open ms word and get the codes from there