| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining the full path and filename of an active workbook
Is there any way to determine the full path and filename of the active
workbook? I'm writing a macro that creates and saves files, and I'd like it to reference the full path of the file so that I can use the same program to open and view the files afterwards. Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determining the full path and filename of an active workbook
thisworkbook.path
should do it -- Gary "Aaron Dyck" wrote in message ... Is there any way to determine the full path and filename of the active workbook? I'm writing a macro that creates and saves files, and I'd like it to reference the full path of the file so that I can use the same program to open and view the files afterwards. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to see full path name of open workbook? | Excel Discussion (Misc queries) | |||
| macro to paste active cell's full path into another cell | Excel Programming | |||
| extract filename from full path | Excel Programming | |||
| Extract full path given filename | Excel Programming | |||
| Trim path from full filename | Excel Programming | |||
Hybrid Mode
