Macro: import multiple text files from a single directory and insert a column of numbers between each file

[Chimichengas56]

Hi all,

I need a macro that will access a single directory and import all of the files within it into adjacent columns of the same worksheet in excel. The caveat is that between each column, I also need to insert a range of numbers, beginning at 0 and going to 20.47 in 0.01 increments.

The import of the text files needs to import the data beginning at row 22. Column A should contain the data from the first imported file, column B should have the column of numbers, column C should have the data from the second imported file, column D should have the column of numbers... and so on.

Thanks in advance for your help,

Chimi