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

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.

.