 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2008Footer to list Directory & Filename
I can get the Filename to list in the foot. But, I need the Directory information to also print. How can this be done? Private Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet.PageSetup .LeftFooter = ThisWorkbook.FullName End With End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code  SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >I can get the Filename to list in the foot. But, I need the Directory > information to also print. How can this be done? Ok, I work in an office with people that won't understand how to do this. And even if they did, they would mess it up. I need a code that goes in the Custom Footer section that will print up the Directory information, ie &[File] prints the file name. > Private Sub Workbook_BeforePrint(Cancel As Boolean) > With ActiveSheet.PageSetup [quoted text clipped - 9 lines] > >I can get the Filename to list in the foot. But, I need the Directory > > information to also print. How can this be done? &[Path]&[File] You can't just get the folder and file name SignatureRegards, Peo Sjoblom > Ok, I work in an office with people that won't understand how to do this. > And even if they did, they would mess it up. [quoted text clipped - 16 lines] >> >I can get the Filename to list in the foot. But, I need the Directory >> > information to also print. How can this be done? Ok, I set up in the footer field the &[Path]&[File] and it prints; Path] Filename.xls So, the actual Path name should be G:\Client Folders, and it didn't print. Any more suggestions > &[Path]&[File] > [quoted text clipped - 20 lines] > >> >I can get the Filename to list in the foot. But, I need the Directory > >> > information to also print. How can this be done? What version of excel are you using? I _think_ the &[Path] was added in xl2002. You may want to try John Walkenbach's AddPath addin: http://j-walk.com/ss/excel/files/addpath.htm > Ok, I set up in the footer field the &[Path]&[File] and it prints; > Path] Filename.xls [quoted text clipped - 41 lines] > > >> >I can get the Filename to list in the foot. But, I need the Directory > > >> > information to also print. How can this be done? SignatureDave Peterson Excel 2000 > What version of excel are you using? > [quoted text clipped - 48 lines] > > > >> >I can get the Filename to list in the foot. But, I need the Directory > > > >> > information to also print. How can this be done? So John's addin worked fine for you?? > Excel 2000 > [quoted text clipped - 54 lines] > > > > Dave Peterson SignatureDave Peterson It didn't work. > So John's addin worked fine for you?? > [quoted text clipped - 56 lines] > > > > > > Dave Peterson That's too bad. It's worked for me and lots of other people. > It didn't work. > [quoted text clipped - 62 lines] > > > > Dave Peterson SignatureDave Peterson Click the icon that looks like an open folder and you will get the path SignatureRegards, Peo Sjoblom >I can get the Filename to list in the foot. But, I need the Directory > information to also print. How can this be done?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.