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
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
Hey Phil,
If using the Dialogs collection, you can just use the native syntax of it, it's the first argument ...
[vba]Sub saveasfooey()
Application.Dialogs(xlDialogSaveAs).Show Range("A1").Value
End Sub[/vba]
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Zack,
As usual, thanks for your help
Phil
Put that in a BeforeSave event procedurtes and it will be peachy!
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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