Opening multiple files and importing into Excel

Evening everyone,

I have a number of .csa files, all of which I need to import into Excel. Each file I would like to import into the same workbook, however each on a different sheet.

The files are stored in the following directory:

C:/Analysis

All .csa files are delimited and comma separated.

I would like a macro which imports all of the files which are located in the directory onto separate sheets. I will have to perform this exercise a number a times, hence why I feel a macro would be so useful!

Thanks in advance!

Get started by doing the manual steps with the macro recorder: import one file and add a new sheet. Edit the code as required to remove unnecessary Selects etc. and use the Dir function to loop through the files in folder (searching should find many examples).