LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Problem with Dialogs(xlDialogWorkbookNew)

Jim, thanks for your answer.

xlDialogNew opens the task pane on my system, that is not what I want.

Dialogs(xlDialogWorkbookNew) opens exactly the dialog I want, but the
problem is, it did not work the way I wanted it. When I open the dialog
from the link in the task pane instead (with "General templates...")
all works fine. But when I use Dialogs(xlDialogWorkbookNew) a new
template is not opened, but inserted in an already open workbook.

It would be of interest to me, if you somebody can reproduce this
behaviour.
1. create a template test.xlt and save it to the templates folder
2. rename one sheet in test.xlt to something different e.g. testsheet,
delete all other sheets and then save & exit test.xlt
3. Exit Excel and open it again. you will see your standard new
workbook with the standard sheet1 to sheet3 in it
4. Go to Extra-Macro-Visual Basic and execute the command
dlgAnswer = Application.Dialogs(xlDialogWorkbookNew).Show
in the direct window
5. In the now open template dialog, select your template test.xlt

When it opens I see a workbook with four sheets, which are the three
standard sheet1 to sheet3 plus the renamed testsheet from test.xlt.
This is, because Excel has not created a new Workbook based on test.xlt
as it should, but it has merged the sheets from test.xlt into the
currently open workbook.

But then again, maybe that is only me, and nobody else experiences this
strange behaviour.

thanks again, for any help

Andreas

 
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
The Dialogs collection James Butler Excel Programming 2 May 3rd 05 02:39 AM
Dialogs nc Excel Discussion (Misc queries) 1 March 23rd 05 02:17 PM
problems with dialogs François Excel Programming 5 February 21st 05 10:34 AM
Dialogs Command Stratuser Excel Programming 0 February 12th 04 03:43 PM
Using Dialogs Save Stratuser[_2_] Excel Programming 0 July 22nd 03 08:59 PM


All times are GMT +1. The time now is 06:57 PM.

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"