Excel Macro: Add Next Row in a Loop

[foxy_420]

Hey guys,

I have a macro that cycles through a directory and imports all the "csv" files. As of right now, the data is all put into Row 1.

I was hoping that each new file would be imported into the row below (ie. Row 1 = 1st file, row 2 = 2nd file, row 3 = 3rd file etc...)

Any ideas on how I can fix this?

Please Login or Register  to view this content.

[HaHoBe]

Hi, foxy_420,

maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger

[foxy_420]

Thank you for the quick response, this is exactly what I wanted