Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path in Footer
I once used this a while back but can not find referance to it anymore -
in the footer the dockument path would be displayed/printed helping users find the document in the network share I believe it was a VBS script apply to the Excel template --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path in Footer
Geoff,
2nd time today. This is built into xl2002, &[Path]&[File], but earlier versions required a macro . This code, placed in the ThisWorkbook code module, automatically sets the full name when printing. Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftFooter = ThisWorkbook.FullName End Sub If you just want the path, change FullName to Parth. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "GeoffM " wrote in message ... I once used this a while back but can not find referance to it anymore - in the footer the dockument path would be displayed/printed helping users find the document in the network share I believe it was a VBS script apply to the Excel template --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path in Footer
Thanks Bob, I forgot to mention that this particular Customer is al
Office 2000 - I had searched on the forums before posting including th Tips section might be good to sticky in the tips section. -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path in Footer
John Walkenbach has an addin that may help:
http://j-walk.com/ss/excel/files/addpath.htm "GeoffM <" wrote: Thanks Bob, I forgot to mention that this particular Customer is all Office 2000 - I had searched on the forums before posting including the Tips section might be good to sticky in the tips section.. --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
full UNC path in footer | Excel Discussion (Misc queries) | |||
Path in page footer | Excel Discussion (Misc queries) | |||
Path and File Name to Footer | Excel Discussion (Misc queries) | |||
Footer - FileName and Path | Excel Discussion (Misc queries) | |||
Entering Path Name in Footer | Excel Worksheet Functions |