Headers/Footers

[wmclachlin]

Sorry to trouble you all with such a basic question. But anyways.

My question is how can I insert the path to the filename into the header/footer? It's nice to be able to insert the filename but is pretty useless if others don't know where to find it.

Thanks,
Wes

 

[Corticus]

go to page setup, click on the footer/header tab, select custom header, pick the field in the middle(or wherever you want it) and finally,click on the little Excel icon one from the right on the custom header tab.

Corticus

 

[Barry Katcher]

Here's a macro for your PERSONAL macro workbook:

Sub InsertPathInFooter()
' InsertPathInFooter Macro
' Macro recorded 1/25/2002 by bkatc
ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName
End Sub

_________________
...and I always put the seat down.
This message was edited by Barry Katcher on 2002-05-09 07:40

 

[wmclachlin]

Thanks for the macro. There isn't a way to do it without one is there?

Wes

 

[Barry Katcher]

Sure. Click on:
File
Page Setup
Header/Footer
Custom Footer
Then, click on the section you want and type in the full path and file name.

This is exactly what the macro does in 1/1000 of the time.

 

[zzydhf]

I like to use this code incase I change the filename (it doesn't help if you change the path though):
ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.Path & "&F"