If users are using an Excel template, is it possible to get the SaveAs box to open through a macro?
Deb
If users are using an Excel template, is it possible to get the SaveAs box to open through a macro?
Deb
Hi!
Yes: can be done through VBA.
A call such as :
fname = Application.GetSaveAsFilename
will bring up the dialogue box which deals with "Save as"
See GetSaveAsFilename in Visual Basic Help.
Alf
Thanks. That worked well.
Deb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks