How to find out the residing directory of the opened workbook using VBA code ?

  • Thread starter Thread starter Adrian
  • Start date Start date
A

Adrian

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...
 
Adrian said:
How do we find out the residing directory of the opened workbook using
VBA code ? The command "curDir" doesn't seem to work here ...
Click to expand...

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 *
 
Sub test()

MsgBox ActiveWorkbook.FullName, , "Full path of the active workbook"

End Sub

RBS
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wrong current directory 3
Opening workbook in same directory 2
vba browse button set to current directory 2
Open Workbook Macro - with a twist 1
VBA Workbook Open Function 2
workbook_open() sub does not work 2
How to bypass password when pasting FROM a protected workbook 3
change curdir to a folder on a network 2

Back
Top