View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MacroMan MacroMan is offline
external usenet poster
 
Posts: 16
Default Built-in file dialog question

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.