Microsoft KB Archive/303836

= Cannot access the Templates dialog box from a VBA macro in Excel 2002 =

Article ID: 303836

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q303836





SYMPTOMS
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.



RESOLUTION
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 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



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section. This problem was first corrected in Microsoft Office XP Service Pack 1.

Additional query words: XL2002 stop pause new template vba sp-1 sp1

Keywords: kbbug kbdtacode kbfix kbofficexpsp1fix KB303836

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.