CurDir

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

CurDir does not return the present working directory of the
work book. How to get the present working directory of the
work sheet
 
Assuming that the code is in the workbook that you're trying to lodate, use
ThisWorkbook.Path.

HTH

Alan Perkins
 
The folder where the active workbook resides is
ActiveWorkbook.Path

HTH. Best wishes Harald
 

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

vba browse button set to current directory 2
Saving Files 2
Current Working Directory 3
FileDialog(msoFileDialogFolderPicker) not using the current direct 1
CurDir does not work 3
ChDir and ChDrive 2
problems with "CurDir" 2
Wrong current directory 3

Back
Top