ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using XmlImport/Export Fucntions for excel (https://www.excelbanter.com/excel-programming/370770-using-xmlimport-export-fucntions-excel.html)

Umair Hasan

Using XmlImport/Export Fucntions for excel
 
All the functions for importing/exporting xml from/into an excel sheet that
have an "out" variable as an argument are throwing COM exceptions.

for example:
Globals.ThisWorkbook.XmlImport(("F:\\temp\\aa.xml" ), out map, missing,
missing) is not working but
map.Import("F:\\temp\\aa-2.xml", missing) is working

Similarly:
map.ExportXml(out xmlString) is not working but
map.Export("F:\\temp\\result.xml", overwrite) is working

Here is the exception: {"Type mismatch. (Exception from HRESULT: 0x80020005
(DISP_E_TYPEMISMATCH))"}

any thoughts??


All times are GMT +1. The time now is 07:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com