Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Cannot access the Templates dialog box from a VBA macro in Excel 2002

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

View products that this article applies to.

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.

↑ Back to the top

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

↑ Back to the top

Status

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.

↑ Back to the top

Keywords: KB303836, kbofficexpsp1fix, kbfix, kbdtacode, kbbug

↑ Back to the top

Article Info
Article ID : 303836
Revision : 5
Created on : 1/31/2007
Published on : 1/31/2007
Exists online : False
Views : 265