How to adjust this code to import a csv file rather than xml

    ActiveWorkbook.XmlImport URL:= _
        Loc, ImportMap:= _
        Nothing, Overwrite:=True, Destination:=Range("$A$1")

Loc is a string variable with the name of the file in it.

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!