| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find out the residing directory of the opened workbook using VBA code ?
Sub test()
MsgBox ActiveWorkbook.FullName, , "Full path of the active workbook" End Sub RBS "Adrian" wrote in message ... Hi , How do we find out the residing directory of the opened workbook using VBA code ? The command "curDir" doesn't seem to work here ... Thanks... -- Regards, Adrian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheets select method fails when workbook is opened by another workbook | Excel Programming | |||
| Directory Code | Excel Programming | |||
| Code to check if workbook is the last one opened | Excel Programming | |||
| Capturing the directory when a workbook is opened from Explorer | Excel Programming | |||
| Code to tell if workbook is opened in browser | Excel Programming | |||
Hybrid Mode
