VBA: Import CSV file into an Excel Workbook with user defined file name and directory

I have an Excel Workbook where I need to allow the user to:

1. Select a csv file (user needs to be able to select both the file name and the directory)
2. Open the file
3. Save the csv file to a worksheet within the workbook

I have been unable to find or craft a solution myself to accomplish these tasks in a single macro. Any solutions or suggestions would be greatly appreciated.

Hi
how will the macro know which directories to offer the user - do you have a list?

Hi

this macro will offer the user a list of all the csv files in the specified directory, open the nominated file and copy its sheets to the end of the active workbook.

If you also want the user to choose the directory, let me know how to establish the list

Please Login or Register  to view this content.

Nicky,

Thanks for the assistance. I want the user to essentially be able to chose any directory, as if they were using the File Open dialogue box.

They will pick a single csv file and the data from the csv file will be copied onto a cleared worksheet named "MLS Feed"

Larry