Loc is a string variable with the name of the file in it.![]()
ActiveWorkbook.XmlImport URL:= _ Loc, ImportMap:= _ Nothing, Overwrite:=True, Destination:=Range("$A$1")
I tried the whole "use the macro recorder and see what happens" thing but the code wouldn't work at all.
I just want to import a CSV as comma delimited sheet because it turns out the csv files for this import are half the size of the xml and import much faster!
Bookmarks