Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 303836 - Last Review: January 31, 2007 - Revision: 3.2
Cannot access the Templates dialog box from a VBA macro in Excel 2002
This article was previously published under Q303836
When you run a Microsoft Visual Basic for Applications (VBA) macro to display the
Templates dialog box (
xlDialogNew) for creating a new file, Microsoft Excel displays the
New Workbook task pane instead. The macro does not pause for you to select a file or a template to open, nor does it capture your selection.
To resolve this problem, obtain the latest service pack for Microsoft Office XP. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
307841Â
(http://kbalertz.com/Feedback.aspx?kbNumber=307841/
)
OFFXP: How to obtain the latest Office XP service pack
The English version of this fix should have the following file attributes or later:
Date Time Version Size File name
--------------------------------------------------------
09-AUG-2001 18:28:16 10.0.3207 8.74MB Excel.exe
09-AUG-2001 18:28:20 10.0.3207 2.04MB Graph.exe
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft Office XP Service Pack 1.
APPLIES TO
- Microsoft Excel 2002 Standard Edition
| kbbug kbdtacode kbfix kbofficexpsp1fix KB303836 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate