How can I open an xml file into the existing workbook, and not open a new workbook? I have this code
But it opens a new workbook, I'd really like the xml list to show up in the already open "Sheet1".Code:Globals.ThisWorkbook.Application.Workbooks.OpenXML( @"c:\temp\SportsFeed.xml", System.Type.Missing, XlXmlLoadOption.xlXmlLoadImportToList);
Thanks,
Mike




Reply With Quote