#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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



.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row select mode to highlight active row of active cell Bart Fay[_2_] Excel Discussion (Misc queries) 0 May 11th 10 09:34 PM
referring to formula in a non active cell from active cell nickname Excel Discussion (Misc queries) 1 June 21st 07 12:11 PM
Active X controls dksoreal Excel Discussion (Misc queries) 2 June 30th 05 02:35 PM
HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. ragman10 Excel Discussion (Misc queries) 1 December 13th 04 11:52 PM
Last Active Eric[_8_] Excel Programming 1 July 23rd 03 02:49 PM


All times are GMT +1. The time now is 11:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"