Macro to import .csv from browse for file location dialog box.

I am trying to automate preparing csv files for import into another program. I have created a button to run a macro to import .csv.

Please Login or Register  to view this content.

It lets me chose the file from the browse for location dialog box, but I get an error before the data is loaded.

Run time error '1004':
Excel cannot find the text file to refresh this external data range.
Check to make sure the text file has not been moved or renamed, then try the refresh again.

At this point in the code:

Please Login or Register  to view this content.

I am working with Excel 2010 and 2013, if there are conflicts I would rather it to work with Excel 2013