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.

Yo! Sorry all, I just figured it out...hope this didn't
inconvenience...

-----Original Message-----
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.

.