Solved: SaveAs - Default Name

[Philcjr]

All,

In Excel 2000, how can I make it so that when a user selects "SaveAs" the file name in the SaveAsDialogbox will default to what is in cell A1

Thanks,
Phil

[Zack Barresse]

Hey Phil,

If using the Dialogs collection, you can just use the native syntax of it, it's the first argument ...

Sub saveasfooey()
Application.Dialogs(xlDialogSaveAs).Show Range("A1").Value
End Sub

[Philcjr]

Zack,

As usual, thanks for your help:thumb

Phil

[Bob Phillips]

Put that in a BeforeSave event procedurtes and it will be peachy!

[Philcjr]

Mr. XLD,

Actually, I did that and it kindof worked.

* The SaveAs dialogbox appears
* The FileName appears
* The file saves

Then another SaveAs dialogbox appears again, hummmmmmm?

Any ideas as to why?

Thanks,
Phil