I need to use VBA to set directory

G

Guest

Good afternoon,

I am using VBA modules to do various tasks in Access and I need to know what
commands to use to set a directory so that when I display the open dialogue
box, will show a specified directory? Any suggestions? Thanks,

Cordially,
 
B

Barry-Jon

Open a module and go to tools>refernces to ensure you have a reference
to the microsoft office object library. Then the following code should
work.


Dim fd As FileDialog

Set fd = Application.FileDialog(msoFileDialogOpen)

With fd
.InitialFileName = "C:\"
'etc.... etc....
End With
 

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

Need VBA assistance for Open Dialoge Box 1
I need VBA assistance to set a directory in Access module 2
Need to find out VBA command that runs "Open" file dialogue box 1
I need VBA Assistance to test for instances 2
Need to use VBA to print to default printer 1
Override dialogue prompt for overwrite during export 2
Password Protect A Directory 1
Need VBA code for "Open Dialogue" box 2

Top