Import CSV with VBA code fails on 2nd import

I have VBA importing multiple CSV files onto a Sheet using the code below.

It works on the 1st CSV file imported, but any subsequent files it loads in one column only. The CSV file is ok, since it imports properly manually using Excel's dialog box for importing CSV files.

Is there a reason why it fails in VBA?

Thanks,
Ron
Here's the code for importing...

Please Login or Register  to view this content.

Try this code

Please Login or Register  to view this content.