Path Name

[kbutler]

I need the path name to automatically show up in the
footer. This is for Office 2000. I have followed the
instructions on the website, but they require you to save
the file first, I don't want to do that. Also, I need to
be able to open up an exisiting file that another user has
created and the path name automatically show up in the
footer.

 

[Frank Kabel]

Hi
see your post in Excel.misc

 

[Govind]

Hi,

If you want the entire path to be displayed on a particular cell, you
can use

=CELL("filename",A1)

If you place it somewhere down in the worksheet you can use it as a
footer also.

Dont think this is complete solution, but in case you dont have any
other better solution you can use this.

Govind.

 

[Frank Kabel]

Hi
but this would also require to save the file first