Active X

[njavdan]

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

 

[Tom Ogilvy]

The easiest is to use

Application.GetSaveAsFileName()

but to answer the specific question.

application.Dialogs(xlDialogSaveAs).Show

? xlDialogSaveAs
5

 

[njavdan]

Tom

Many thanks. It worked. Would you please let me know
where I can find all the possible values for property
Dialogs. I'll have to use print, ... later on.

Regards

Nasser

 

[Tom Ogilvy]

In Excel VBA help it is listed under this topic:

Built-In Dialog Box Argument Lists