![]() |
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