application.filedialog

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

Guest

I'm using the application.filedialog method to get a file. I want to set the
default directory where this dialog opens up... any ideas??

(*** I tried
chdrive "C:"
then
chdir "C:\whatever")

didn't seem to work
 
TomHinkle said:
I'm using the application.filedialog method to get a file. I want to
set the default directory where this dialog opens up... any ideas??

(*** I tried
chdrive "C:"
then
chdir "C:\whatever")

didn't seem to work
Click to expand...


Dim dlgOpen As FileDialog

Set dlgOpen = Application.FileDialog(msoFileDialogOpen)

With dlgOpen
.InitialFileName = "C:\"
.Show
End With
 
Back
Top