Active X

  • Thread starter Thread starter njavdan
  • Start date Start date
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
 
The easiest is to use

Application.GetSaveAsFileName()

but to answer the specific question.

application.Dialogs(xlDialogSaveAs).Show

? xlDialogSaveAs
5
 
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
 
Back
Top