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


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
news:8B269F40-5D55-41D4-AE73-63A84EC7C564@microsoft.com...
>I can get the Filename to list in the foot. But, I need the Directory
> information to also print. How can this be done?

Click the icon that looks like an open folder and you will get the path

--


Regards,


Peo Sjoblom


"TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
news:8B269F40-5D55-41D4-AE73-63A84EC7C564@microsoft.com...
>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.

"Bob Phillips" wrote:

> 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
>
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
> news:8B269F40-5D55-41D4-AE73-63A84EC7C564@microsoft.com...
> >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


--


Regards,


Peo Sjoblom


"TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
news:E349A43C-B972-4DCE-838D-01E6A2CEA8DC@microsoft.com...
> 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.
>
> "Bob Phillips" wrote:
>
>> 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
>>
>>
>> --
>> HTH
>>
>> Bob
>>
>> (there's no email, no snail mail, but somewhere should be gmail in my
>> addy)
>>
>> "TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
>> news:8B269F40-5D55-41D4-AE73-63A84EC7C564@microsoft.com...
>> >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

"Peo Sjoblom" wrote:

> &[Path]&[File]
>
> You can't just get the folder and file name
>
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
> "TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
> news:E349A43C-B972-4DCE-838D-01E6A2CEA8DC@microsoft.com...
> > 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.
> >
> > "Bob Phillips" wrote:
> >
> >> 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
> >>
> >>
> >> --
> >> HTH
> >>
> >> Bob
> >>
> >> (there's no email, no snail mail, but somewhere should be gmail in my
> >> addy)
> >>
> >> "TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
> >> news:8B269F40-5D55-41D4-AE73-63A84EC7C564@microsoft.com...
> >> >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

TigerLady wrote:
>
> 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
>
> "Peo Sjoblom" wrote:
>
> > &[Path]&[File]
> >
> > You can't just get the folder and file name
> >
> >
> > --
> >
> >
> > Regards,
> >
> >
> > Peo Sjoblom
> >
> >
> > "TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
> > news:E349A43C-B972-4DCE-838D-01E6A2CEA8DC@microsoft.com...
> > > 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.
> > >
> > > "Bob Phillips" wrote:
> > >
> > >> 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
> > >>
> > >>
> > >> --
> > >> HTH
> > >>
> > >> Bob
> > >>
> > >> (there's no email, no snail mail, but somewhere should be gmail in my
> > >> addy)
> > >>
> > >> "TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
> > >> news:8B269F40-5D55-41D4-AE73-63A84EC7C564@microsoft.com...
> > >> >I can get the Filename to list in the foot. But, I need the Directory
> > >> > information to also print. How can this be done?
> > >>
> > >>
> > >>
> >
> >
> >

--

Dave Peterson

Excel 2000

"Dave Peterson" wrote:

> 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
>
> TigerLady wrote:
> >
> > 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
> >
> > "Peo Sjoblom" wrote:
> >
> > > &[Path]&[File]
> > >
> > > You can't just get the folder and file name
> > >
> > >
> > > --
> > >
> > >
> > > Regards,
> > >
> > >
> > > Peo Sjoblom
> > >
> > >
> > > "TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
> > > news:E349A43C-B972-4DCE-838D-01E6A2CEA8DC@microsoft.com...
> > > > 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.
> > > >
> > > > "Bob Phillips" wrote:
> > > >
> > > >> 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
> > > >>
> > > >>
> > > >> --
> > > >> HTH
> > > >>
> > > >> Bob
> > > >>
> > > >> (there's no email, no snail mail, but somewhere should be gmail in my
> > > >> addy)
> > > >>
> > > >> "TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
> > > >> news:8B269F40-5D55-41D4-AE73-63A84EC7C564@microsoft.com...
> > > >> >I can get the Filename to list in the foot. But, I need the Directory
> > > >> > information to also print. How can this be done?
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >
>
> --
>
> Dave Peterson
>

So John's addin worked fine for you??

TigerLady wrote:
>
> Excel 2000
>
> "Dave Peterson" wrote:
>
> > 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
> >
> > TigerLady wrote:
> > >
> > > 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
> > >
> > > "Peo Sjoblom" wrote:
> > >
> > > > &[Path]&[File]
> > > >
> > > > You can't just get the folder and file name
> > > >
> > > >
> > > > --
> > > >
> > > >
> > > > Regards,
> > > >
> > > >
> > > > Peo Sjoblom
> > > >
> > > >
> > > > "TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
> > > > news:E349A43C-B972-4DCE-838D-01E6A2CEA8DC@microsoft.com...
> > > > > 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.
> > > > >
> > > > > "Bob Phillips" wrote:
> > > > >
> > > > >> 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
> > > > >>
> > > > >>
> > > > >> --
> > > > >> HTH
> > > > >>
> > > > >> Bob
> > > > >>
> > > > >> (there's no email, no snail mail, but somewhere should be gmail in my
> > > > >> addy)
> > > > >>
> > > > >> "TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
> > > > >> news:8B269F40-5D55-41D4-AE73-63A84EC7C564@microsoft.com...
> > > > >> >I can get the Filename to list in the foot. But, I need the Directory
> > > > >> > information to also print. How can this be done?
> > > > >>
> > > > >>
> > > > >>
> > > >
> > > >
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

It didn't work.

"Dave Peterson" wrote:

> So John's addin worked fine for you??
>
> TigerLady wrote:
> >
> > Excel 2000
> >
> > "Dave Peterson" wrote:
> >
> > > 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
> > >
> > > TigerLady wrote:
> > > >
> > > > 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
> > > >
> > > > "Peo Sjoblom" wrote:
> > > >
> > > > > &[Path]&[File]
> > > > >
> > > > > You can't just get the folder and file name
> > > > >
> > > > >
> > > > > --
> > > > >
> > > > >
> > > > > Regards,
> > > > >
> > > > >
> > > > > Peo Sjoblom
> > > > >
> > > > >
> > > > > "TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
> > > > > news:E349A43C-B972-4DCE-838D-01E6A2CEA8DC@microsoft.com...
> > > > > > 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.
> > > > > >
> > > > > > "Bob Phillips" wrote:
> > > > > >
> > > > > >> 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
> > > > > >>
> > > > > >>
> > > > > >> --
> > > > > >> HTH
> > > > > >>
> > > > > >> Bob
> > > > > >>
> > > > > >> (there's no email, no snail mail, but somewhere should be gmail in my
> > > > > >> addy)
> > > > > >>
> > > > > >> "TigerLady" <TigerLady@discussions.microsoft.com> wrote in message
> > > > > >> news:8B269F40-5D55-41D4-AE73-63A84EC7C564@microsoft.com...
> > > > > >> >I can get the Filename to list in the foot. But, I need the Directory
> > > > > >> > information to also print. How can this be done?
> > > > > >>
> > > > > >>
> > > > > >>
> > > > >
> > > > >
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>