problem in opening XML with EXCEL via VB6

[eranfox]

Hello Everybody,
I'm working on a project with XML files.
I have XML file called (for e.g.) myXMLFile.XML
I also have XSL file called (for e.g.) myXSLFile.XSL
When i wrote a VBA Macro in EXCEL it looked like this:

Workbooks.OpenXML Filename:="C:\myXMLFile.XML", Stylesheets:=Array(1)

when i opend the excel with the VBA Macro it didn't ask me how to open the XML file - the xml file was opend automatically with the design that was written in the XSL file.

BUT!!! when i tried to write the same code in VB6 it did'nt work:

objExcel.Workbooks.OpenXML FileName:="C:\myXMLFile.XML", Stylesheets:=Array(1)

the excel poped up the question : how to open the XML File?

How can i open the XML file automatically without the poped question?

Thank you all in advance,
ERAN