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