| 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 ?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to find out the residing directory of the opened workbook using VBA code ?
"Adrian" wrote in message
... How do we find out the residing directory of the opened workbook using VBA code ? The command "curDir" doesn't seem to work here ... Hi Adrian, I think ThisWorkbook.Path is what you're looking for. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
|
#3
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 | |||
![Adrian[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
