Footers

Bobthebuilder · May 22nd, 2002, 09:24 AM

Does anybody know where I can find the commands to put in the footer, for example, to include filenames, tab names, but more specifically, the path name of the file

zzydhf · May 22nd, 2002, 09:32 AM

you should do a search. there has been a lot about this...

here is one:
http://www.mrexcel.com/board/viewtop...c=7780&forum=2

philR · May 22nd, 2002, 09:40 AM

Excel divides the footer (and header) into 3 sections: left, center and right. This will put stuff in the left footer, but obviously its easy to change!

Put this in a module:

Sub PathAndFilename()
mypath = CurDir()
myfile = Application.ActiveWorkbook.Name
ActiveSheet.PageSetup.LeftFooter = mypath & "" & myfile
End Sub

[ This Message was edited by: philR on 2002-05-22 08:41 ]

[ This Message was edited by: philR on 2002-05-22 08:42 ]

[ This Message was edited by: philR on 2002-05-22 08:43 ]

philR · May 22nd, 2002, 09:45 AM

What is going on with this editor??? I am trying to edit the previous message to get a SINGLE BACKSLASH between the quotes, but it either prints 2 or none. Anyway, there is supposed to be a SINGLE BACKSLASH FOR GOD'S SAKE between the quotes. I give up.

[ This Message was edited by: philR on 2002-05-22 08:46 ]

stone · May 22nd, 2002, 09:59 AM

Just go to FILE-Page setup Header/footer

Von Pookie · May 22nd, 2002, 10:21 AM

Funny. I always just go to ViewHeader and Footer

inarbeth · May 22nd, 2002, 10:39 AM

Damon Ostrander provided a useful list here: http://www.mrexcel.com/board/viewtop...7128&forum=2&5

May 22nd, 2002, 10:21 AM	#6
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Funny. I always just go to ViewHeader and Footer __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 09:24 AM	#1
Bobthebuilder Board Regular Join Date: May 2002 Location: Telephone City Posts: 76	Does anybody know where I can find the commands to put in the footer, for example, to include filenames, tab names, but more specifically, the path name of the file

May 22nd, 2002, 09:32 AM	#2
zzydhf Board Regular Join Date: Apr 2002 Location: N.E. Ohio Posts: 236	you should do a search. there has been a lot about this... here is one: http://www.mrexcel.com/board/viewtop...c=7780&forum=2

May 22nd, 2002, 09:40 AM	#3
philR Board Regular Join Date: Feb 2002 Location: Sheffield, UK Posts: 249	Excel divides the footer (and header) into 3 sections: left, center and right. This will put stuff in the left footer, but obviously its easy to change! Put this in a module: Sub PathAndFilename() mypath = CurDir() myfile = Application.ActiveWorkbook.Name ActiveSheet.PageSetup.LeftFooter = mypath & "" & myfile End Sub [ This Message was edited by: philR on 2002-05-22 08:41 ] [ This Message was edited by: philR on 2002-05-22 08:42 ] [ This Message was edited by: philR on 2002-05-22 08:43 ]

May 22nd, 2002, 09:45 AM	#4
philR Board Regular Join Date: Feb 2002 Location: Sheffield, UK Posts: 249	What is going on with this editor??? I am trying to edit the previous message to get a SINGLE BACKSLASH between the quotes, but it either prints 2 or none. Anyway, there is supposed to be a SINGLE BACKSLASH FOR GOD'S SAKE between the quotes. I give up. [ This Message was edited by: philR on 2002-05-22 08:46 ]

May 22nd, 2002, 09:59 AM	#5
stone Board Regular Join Date: Apr 2002 Location: iceland Posts: 138	Just go to FILE-Page setup Header/footer

May 22nd, 2002, 10:39 AM	#7
inarbeth Board Regular Join Date: Apr 2002 Location: Wivenhoe, England Posts: 877	Damon Ostrander provided a useful list here: http://www.mrexcel.com/board/viewtop...7128&forum=2&5