xml to excel data extraction - (Moved)

[VinMe]

Dear all, i am unable to open a xml file to excel in the "xml table format" Please help me out in where i am missing

Local $strFileToOpen = _WinAPI_OpenFileDlg('Select xml file', @WorkingDir, 'All Files(*.*)', 1, '', '', BitOR($OFN_PATHMUSTEXIST, $OFN_FILEMUSTEXIST, $OFN_HIDEREADONLY))

Global $xlXmlLoadImportToList = 2 ; Places the contents of the XML data file in an XML table
$oExcel = _Excel_Open()
$oWorkbook1=$oExcel.Workbooks.OpenXML($strFileToOpen, "", $xlXmlLoadImportToList)
If $strFileToOpen <> False Then
    Local $oWorkbook1 = _Excel_BookOpen($oExcel, $strFileToOpen)
EndIf

Error i am getting is:

......\81e_Compare_v1.au3" (46) : ==> The requested action with this object has failed.:
$oWorkbook1=$oExcel.Workbooks.OpenXML($strFileToOpen, "", $xlXmlLoadImportToList)
$oWorkbook1=$oExcel.Workbooks^ ERROR
>Exit code: 1    Time: 7.338

[Melba23]

Moved to the appropriate forum, as the AutoIt Example Scripts forum very clearly states:

Quote

Share your cool AutoIt scripts, UDFs and applications with others.

---

Do not post general support questions here, instead use the AutoIt Help and Support forums.

Moderation Team

[water]

Add a COM error handler to your script to get more detailed error information. Please have a look at ObjEvent how to do.

[abberration]

Hi,

Water, I found the post where he got this code - it is yours and the other user found it to work. With this code, I have the same problem as the OP. I ran the com error checking and found error # 0x80020006. I looked this up online and found that there may be a problem with MS Office. Running the install CD and running a repair may fix it. Here's the thread:

http://www.whollygenes.com/forums201/index.php?/topic/15979-ole-error-code-0x80020006-unknown-name/

[water]

Thanks for posting this information