Active X
 

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

Active X
 

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

Active X
 

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
-----Original Message-----
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


.

Active X
 

In Excel VBA help it is listed under this topic:

Built-In Dialog Box Argument Lists

--
Regards,
Tom Ogilvy

"njavdan" wrote in message
...
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
-----Original Message-----
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


.