PDA

View Full Version : Solved: SaveAs - Default Name



Philcjr
10-13-2005, 03:07 PM
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
10-13-2005, 03:10 PM
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
10-13-2005, 03:15 PM
Zack,

As usual, thanks for your help:thumb

Phil

Bob Phillips
10-13-2005, 03:17 PM
Put that in a BeforeSave event procedurtes and it will be peachy!

Philcjr
10-13-2005, 05:06 PM
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