Hi,
I've got a problem, I need to import XML files into excel, however some of these are far too big and excel complains that it can't import the data (imports the column headers ok tho!)
A number of the smaller XML files can be imported and then processed removing the unnecessary blank or useless rows or columns.
If I could avoid this 'data correcting' then that would be awesome.
Thoughts on how to select only the columns of data I want?
I want to keep columns "Value, "Alias4" and "ExtractOrDistValue".
Thoughts?
Currently using:
ActiveWorkbook.XMLImport _
URL:=Excel_Path & Sheet(iSheet, 2) & ".xml", _
ImportMap:=Nothing, _
OverWrite:=True, _
Destination:=Excel_Sheet.Range("$A$1")
Thanks!!
Bookmarks