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.
---------------
Tykhung.

Tykhung,
Unless you have excel 2002 or later I think you need a macro, see here
http://www.mvps.org/dmcritchie/excel...ame.htm#footer
If you have not used macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm

The first link also has a link to the 2002 instructions but here it is
anyway
http://support.microsoft.com/default...;en-us;Q287482

Barbara.

Tykhung wrote:
> 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.
> ---------------
> Tykhung.

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
> ---------------
> Tykhung.
>
>
>
>
>

Hi Jamie
AFAIK this feature was introduced in Excel 2002 (or 2000)

--
Regards
Frank Kabel
Frankfurt, Germany


Jamie wrote:
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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.
>> ---------------
>> Tykhung.

I stand corrected! Thanks.

"Frank Kabel" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Jamie
> AFAIK this feature was introduced in Excel 2002 (or 2000)
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
>
> Jamie wrote:
> > 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" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >> 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.
> >> ---------------
> >> Tykhung.
>