| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get filename and filepath
How can I get my own filename and filepath?
Is there any function which provides this? Who can help? Robert |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
get filename and filepath
One way:
=LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))) In article , "Robert Ehrlich" wrote: How can I get my own filename and filepath? Is there any function which provides this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
get filename and filepath
MsgBox ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
Robert Ehrlich wrote in message ... How can I get my own filename and filepath? Is there any function which provides this? Who can help? Robert |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
get filename and filepath
Robert,
Use the Path and FullName properties of the Workbook object. For example, Debug.Print ThisWorkbook.Path, ThisWorkbook.FullName -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Robert Ehrlich" wrote in message ... How can I get my own filename and filepath? Is there any function which provides this? Who can help? Robert |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filename extract from Filepath Text String | Excel Discussion (Misc queries) | |||
| Can I set a default to add a filepath footer when printing? | Excel Discussion (Misc queries) | |||
| Filepath | Excel Discussion (Misc queries) | |||
| Filepath | Excel Discussion (Misc queries) | |||
| Selecting File and FilePath | Excel Programming | |||
Linear Mode
