CurDir does not work

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

Guest

Hi,

My "CurDir" does not work. I have:

Dim File_path As String
File_path = CurDir("")

Instead of showing my current directory (where the workbook I currently have
open lies), is it showing the directory of previously opened file, i.e. the
top file in the quick access list of files that can be found in the
menu/files.

Please help,
 
or activeworkbook.path
Hi,

My "CurDir" does not work. I have:

Dim File_path As String
File_path = CurDir("")

Instead of showing my current directory (where the workbook I currently have
open lies), is it showing the directory of previously opened file, i.e. the
top file in the quick access list of files that can be found in the
menu/files.

Please help,
Click to expand...
 

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
CurDir 2
CurDir 3
FileDialog(msoFileDialogFolderPicker) not using the current direct 1
Saving Files 2
Wrong current directory 3
Workaround for ChDir/CurDir when path has unicode characters 4
Setting CurDir with a Windows File Open dialog box 3

Back
Top