S sokevin Feb 20, 2004 #1 i know i can do =cell("filename") but i want to do this in the footer. how do i go about this? thanks :
i know i can do =cell("filename") but i want to do this in the footer. how do i go about this? thanks :
G Gord Dibben Feb 21, 2004 #2 sokevin If using XL2002 or newer you can enter the path and filename in the footer by going to View>Headers and Footers and "Custom" If earlier version of Excel you need a macro. Sub PathInFooter() ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName & " " & _ ActiveSheet.Name & " " & Application.UserName & " " & Date End Sub Strip out what you don't want from this code. Gord Dibben Excel MVP
sokevin If using XL2002 or newer you can enter the path and filename in the footer by going to View>Headers and Footers and "Custom" If earlier version of Excel you need a macro. Sub PathInFooter() ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName & " " & _ ActiveSheet.Name & " " & Application.UserName & " " & Date End Sub Strip out what you don't want from this code. Gord Dibben Excel MVP
D Dave Peterson Feb 21, 2004 #3 It's built into xl2002, but before that you need a macro approach. Instead of writing one yourself, you could use John Walkenbach's addin: http://j-walk.com/ss/excel/files/addpath.htm
It's built into xl2002, but before that you need a macro approach. Instead of writing one yourself, you could use John Walkenbach's addin: http://j-walk.com/ss/excel/files/addpath.htm
