Footer - FileName and Path
 

Friends,

Is there a way to insert not only the file name but also the path into an
Excel Worksheet footer (like you can in Word)?

Thanks,

Bill Morgan

This code, placed in the ThisWorkbook code module, automatically picks up
the cell value when printing.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = Activeworkbook.FullName
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bill_morgan_3333" wrote in
message ...
Friends,

Is there a way to insert not only the file name but also the path into an
Excel Worksheet footer (like you can in Word)?

Thanks,

Bill Morgan

Hi
see:
http://www.mcgimpsey.com/macoffice/e...einfooter.html

--
Regards
Frank Kabel
Frankfurt, Germany
"bill_morgan_3333" schrieb im
Newsbeitrag ...
Friends,

Is there a way to insert not only the file name but also the path into an
Excel Worksheet footer (like you can in Word)?

Thanks,

Bill Morgan

Bill

Also FYI

If you are running Excel 2002 or 2003 there is a button for entering the full
path into a footer/header in the header/footer Custom setup dialog.

Gord Dibben Excel MVP

On Thu, 30 Dec 2004 00:20:45 +0100, "Frank Kabel"
wrote:

Hi
see:
http://www.mcgimpsey.com/macoffice/e...einfooter.html

--
Regards
Frank Kabel
Frankfurt, Germany
"bill_morgan_3333" schrieb im
Newsbeitrag ...
Friends,

Is there a way to insert not only the file name but also the path into an
Excel Worksheet footer (like you can in Word)?

Thanks,

Bill Morgan

Thanks, Bob. I'll put this to work.

"Bob Phillips" wrote:

This code, placed in the ThisWorkbook code module, automatically picks up
the cell value when printing.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = Activeworkbook.FullName
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bill_morgan_3333" wrote in
message ...
Friends,

Is there a way to insert not only the file name but also the path into an
Excel Worksheet footer (like you can in Word)?

Thanks,

Bill Morgan

Will do ... thanks, Frank ...

"Frank Kabel" wrote:

Hi
see:
http://www.mcgimpsey.com/macoffice/e...einfooter.html

--
Regards
Frank Kabel
Frankfurt, Germany
"bill_morgan_3333" schrieb im
Newsbeitrag ...
Friends,

Is there a way to insert not only the file name but also the path into an
Excel Worksheet footer (like you can in Word)?

Thanks,

Bill Morgan

Gord,

I should have mentioned that this is Excel 2000 - but good to know that
later versions have this feature - thanks ...

"Gord Dibben" wrote:

Bill

Also FYI

If you are running Excel 2002 or 2003 there is a button for entering the full
path into a footer/header in the header/footer Custom setup dialog.

Gord Dibben Excel MVP

On Thu, 30 Dec 2004 00:20:45 +0100, "Frank Kabel"
wrote:

Hi
see:
http://www.mcgimpsey.com/macoffice/e...einfooter.html

--
Regards
Frank Kabel
Frankfurt, Germany
"bill_morgan_3333" schrieb im
Newsbeitrag ...
Friends,

Is there a way to insert not only the file name but also the path into an
Excel Worksheet footer (like you can in Word)?

Thanks,

Bill Morgan