Article ID: 307230 - View products that this article applies to.
This article was previously published under Q307230
When you call the OpenXML method, your code may be interrupted with the Excel Import XML dialog box. User intervention is required for your code to continue. This problem occurs when both of the following conditions are met:
To work around this problem, transform the XML before you open it in Excel and omit the value for the StyleSheets parameter. To do this, use Microsoft XML (MSXML) to load the XML and XSL into DOMDocument objects so that you can transform the XML at run time and save the results to a file. The resulting file can then be opened in Excel without user intervention.
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce the Behavior
For additional information about using XML with Microsoft Excel, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/288215/ )INFO: Microsoft Excel 2002 and XML
(http://support.microsoft.com/kb/285891/ )HOWTO: Use Visual Basic or ASP to create an XML spreadsheet for Excel 2002