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!