View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Umair Hasan Umair Hasan is offline
external usenet poster
 
Posts: 1
Default 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??