| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a file path at bottom of page with no [sheet1]
I've set up a macro to add a FileStamp on the last page of my document. The
formula that I used is: =CELL("filename") It works great, except that it is too thorough :) Is there a different formula that does not add the sheet name information at the end of the path? Thanks in advance for any help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert a file path at bottom of page with no [sheet1]
Ewane,
=LEFT(CELL("filename"),FIND("]",CELL("filename"))) Don "Ewane" wrote in message ... I've set up a macro to add a FileStamp on the last page of my document. The formula that I used is: =CELL("filename") It works great, except that it is too thorough :) Is there a different formula that does not add the sheet name information at the end of the path? Thanks in advance for any help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you automatically insert a file path in an Excel document? | Excel Discussion (Misc queries) | |||
| How do I insert a variable for the file/path in aQuery Table? | Excel Programming | |||
| How do I insert the directory path in my Excel file? | Excel Worksheet Functions | |||
| Insert Text at Bottom of Last Page | Excel Programming | |||
| Insert path and file name in excel 2000 | Excel Programming | |||
Linear Mode
