Input excel file location (address)

**downunderthunder** · 01-21-2010, 10:34 PM

Hi,

I would like to use macros to insert the 'location' of my excel file into the spreadsheet footer. I have the following code already:

Please Login or Register  to view this content.

What should I enter in 'left footer' to get somethin like 'C:\Documents and Settings\user\My Documents\spreadsheet'

Cheers

DUT

**pike** · 01-21-2010, 10:44 PM

Hi downunderthunder
Have a play with

Please Login or Register  to view this content.

**downunderthunder** · 01-21-2010, 11:11 PM

Thanks heaps Pike that worked perfectly

**pike** · 01-22-2010, 01:34 AM

your welcome babana benda

Re: Input excel file location (address)