Change Dir

  • Thread starter Thread starter Luke Bellamy
  • Start date Start date
L

Luke Bellamy

Hi - I was trying to work out how I can set CurDir to return what I want.
I tried "ChDir" command in the VBA code but it didn't make CurDir return
anything different.

Thankyou
 
Ahhh... jumped the gun.
You should always search MVPs.org/access before
asking silling questions

' Add this at the top of the module.
Private Declare Function SetCurrentDirectory _
Lib "kernel32" Alias "SetCurrentDirectoryA" _
(ByVal lpPathName As String) As Long
 
Luke Bellamy said:
Hi - I was trying to work out how I can set CurDir to return what I
want. I tried "ChDir" command in the VBA code but it didn't make
CurDir return anything different.
Click to expand...

That's odd -- it seems to work for me. What exactly did you try?
 
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

Setting CurDir with a Windows File Open dialog box 3
Getting current folder in VBA 6
vba browse button set to current directory 2
Workaround for ChDir/CurDir when path has unicode characters 4
ChDir and ChDrive 2
Chdir before Filedialog 1
FileDialog(msoFileDialogFolderPicker) not using the current direct 1
copying worksheets 3

Back
Top