How do I include file name and path in the header?

M

Matthew Connellan

Work uses 'autotext' to show this data. Does Excel have a similar function?
 
R

Rae Drysdale

Yes, in the header/footer go to custom and there you'll find a lot of options
on the buttons. The 6th and 7th buttons are the ones you want. Hope this
helps.
 
M

Matthew Connellan

The sixth includes hte file name, but I want the whole network path. Word
uses a field: {FILENAME /p} to automatically insert this info. Does Excel
have a similar capability?
 
M

Matthew Connellan

That is the answer I was looking for. I am using version 2000 and the add-in
works perfectly.

Thanks for the help ... Matt
 
Top