How do I put a full path name in the header or trailer

M

Michael L.

I can put a file name in the trailer but I can't seem to
get command to automatically put the path.
 
P

Phil C

Michael

There is a button for path & file (codes as &[Path]&[File]) if you select
custom header in XL2002, but I don't think this was available in previous
versions, in which case you need a macro:

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName & " " & _
Application.UserName & " " & Date
End Sub

HTH, Phil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot Put A Border Around Numbered Text. What To Do? 0
Incorporating the User Profile location into a document template path 1
Error outlook.com 0xc0000005 trying to open custom controls 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Transferspreadsheet - insert rows with no header 1
INSERT to excel file 4
how do I cancel the trailer page when printing in MS Word 2007? 1
Export more rows to a tab delimited file 1

Top