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!!