Hello,
I am relatively new at VBA, so thanks in advance for any help.

I have a program that automatically exports a CSV file. I am trying to develop a macro that 1) prompts the user to select the file, then 2) imports the data into a blank sheet in Excel.

My thoughts so far would be to have a macro that renames the CSV file as .XLS, then use text to columns to format the data. From there, I can have it copy the data.

Any help would be greatly appreciated.