Active X

N

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
 
T

Tom Ogilvy

The easiest is to use

Application.GetSaveAsFileName()

but to answer the specific question.

application.Dialogs(xlDialogSaveAs).Show

? xlDialogSaveAs
5
 
N

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
 
T

Tom Ogilvy

In Excel VBA help it is listed under this topic:

Built-In Dialog Box Argument Lists
 
Top