Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert path and file name in excel 2000
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert path and file name in excel 2000
These formulas put sheet, file and path information into cells:
The file path and name CELL("filename",A1) The file path LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1) The file name MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("fil ename",A1),1)-FIND("[",CELL("filename",A1),1)-1) The sheet name RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename", A1),1)) -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA" "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro help: File path in Excel 2000 | Excel Discussion (Misc queries) | |||
Can you automatically insert a file path in an Excel document? | Excel Discussion (Misc queries) | |||
insert path into excel footer office 2000 | Excel Discussion (Misc queries) | |||
How do I insert the directory path in my Excel file? | Excel Worksheet Functions | |||
Reflect file path (show drive letters) in Excel 2000 | Excel Discussion (Misc queries) |