LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Insert path and file name in excel 2000

Julie,

If you want it in the header/footer, you need VBA.

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


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Julie" wrote in message
...
Is it possible to insert the path and the file name of a
document in excel 2000 ? I know it is possible to do this
in Word 2000 by using the command {FILENAME \p} but it
does'nt works in Excel 2000.

Thank you

Julie



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro help: File path in Excel 2000 macronewfie Excel Discussion (Misc queries) 2 May 26th 06 02:21 PM
Can you automatically insert a file path in an Excel document? Mimi Excel Discussion (Misc queries) 2 March 22nd 06 12:10 AM
insert path into excel footer office 2000 Ace Excel Discussion (Misc queries) 3 August 11th 05 03:08 PM
How do I insert the directory path in my Excel file? Insert a Directory Path in Header/Footer Excel Worksheet Functions 2 February 4th 05 09:23 PM
Reflect file path (show drive letters) in Excel 2000 Alicia Excel Discussion (Misc queries) 4 January 20th 05 06:49 PM


All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"