Chimichengas56
New Member
- Joined
- Oct 4, 2016
- Messages
- 5
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
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