The easiest is to use

Application.GetSaveAsFileName()

but to answer the specific question.

application.Dialogs(xlDialogSaveAs).Show

? xlDialogSaveAs
5

--
Regards,
Tom Ogilvy




"njavdan" wrote in message
...
I have integrated MS Excel into my application using
Active X. Want to open the FileSaveAs dialogue box.

In MS Word, it is referred to as wdDialogFileSaveAs.
What is it referred to in MS Excel.

Thanks