Built-in file dialog question

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.
 

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

Trap on close event and control save 3
Implement time-out 3
Application.FileDialog .Filters.Add method not working as expected 4
filter file extension on remote pc for file open 1
Choose File To SaveAs 6
Application.FileDialog(msoFileDialogSaveAs) 3
import text 1
Excel "Save as" dialog - when file already exists 3

Top