Built-in file dialog question

  • Thread starter Thread starter MacroMan
  • Start date Start date
M

MacroMan

Hello, I hope someone can help me with this.
I am using VBA in Excel XP with Windows 2000.

I am using a buit-in FILE DIALOG to prompt a user to "Save
As", see my code below:

Set oFD = Application.FileDialog(msoFileDialogSaveAs)
With oFD
.AllowMultiSelect = False
.InitialView = msoFileDialogViewDetails
.InitialFileName = myFileName
.Title = "SAVE THIS TIME SHEET!"
If .Show = -1 Then .Execute
End With
Set oFD = Nothing

This works great, however, I want a particular default
path to be displayed everytime this dialog loads. Is there
an argument I'm missing?

Your example code would be most appreciated. Thanks in
advance.
 
Back
Top