Adding the path and filename to all Excel documents automatically.

  • Thread starter Thread starter Tykhung
  • Start date Start date
T

Tykhung

The organziation I work for requires that certain information, especially
the path and filename, appear in the footer of all documents. I have been
able to set this up in Word but I'm stuck as to how to do it in Excel.

Any suggestions would be appreciated.
 
Don't think a macro is nessesary.
Click on File, then Page Setup. Go to Header/Footer and click the Custom
Footer... button.
You can either click the file path button (in 2003 it looks like a folder),
or simply type "&[Path]&[File]" (without the quotes) into which ever section
you would like it to appear.
 
Hi Jamie
AFAIK this feature was introduced in Excel 2002 (or 2000)

--
Regards
Frank Kabel
Frankfurt, Germany

Don't think a macro is nessesary.
Click on File, then Page Setup. Go to Header/Footer and click the
Custom Footer... button.
You can either click the file path button (in 2003 it looks like a
folder), or simply type "&[Path]&[File]" (without the quotes) into
which ever section you would like it to appear.


Tykhung said:
The organziation I work for requires that certain information,
especially the path and filename, appear in the footer of all
documents. I have been able to set this up in Word but I'm stuck as
to how to do it in Excel.

Any suggestions would be appreciated.
Click to expand...
Click to expand...
 
I stand corrected! Thanks.

Frank Kabel said:
Hi Jamie
AFAIK this feature was introduced in Excel 2002 (or 2000)

--
Regards
Frank Kabel
Frankfurt, Germany

Don't think a macro is nessesary.
Click on File, then Page Setup. Go to Header/Footer and click the
Custom Footer... button.
You can either click the file path button (in 2003 it looks like a
folder), or simply type "&[Path]&[File]" (without the quotes) into
which ever section you would like it to appear.


Tykhung said:
The organziation I work for requires that certain information,
especially the path and filename, appear in the footer of all
documents. I have been able to set this up in Word but I'm stuck as
to how to do it in Excel.

Any suggestions would be appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top