| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active Workbook Path
Excel 2003 - I can't seem to capture the path of the current workbook. My
workbook is located at ...\My Documents\Temp Forms\ but MsgBox ThisWorkbook.Path returns ...\Microsoft\Excel\XLSTART and MsgBox ActiveWorkbook.Path returns nothing I'm trying to save one worksheet of a workbook in the "same" directory (whatever that happens to be at a given time). The saving part of my macro works, but the path part doesn't. Thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is path name added to active cell when Excel file is saved? | Excel Discussion (Misc queries) | |||
| Determining the full path and filename of an active workbook | Excel Programming | |||
| macro to paste active cell's full path into another cell | Excel Programming | |||
| Get the path to the directory that the active workbook is in | Excel Programming | |||
| Preventing opening workbook inside active workbook. | Excel Programming | |||
Threaded Mode
