VBA question: Import 100s of .csv files - each in a separate column?

Look into appending the files to each other in Power Query. You will need to have all the files in the same folder.

https://docs.microsoft.com/en-us/pow...bine-files-csv

Hi Alan,

Thanks for the tip! Tried that, but somehow ended up merging all files into one row and again exceeding the max row count.

I found this VBA which seems to do what I want to do, but...

1)...somehow it isn't working if I change the range from A1:A10 to, let's say A1:A1048576 (maximum number of rows)
2) I wouldn't want it to copy the file name in the first row for each file
3) Ideally, I would pick a folder each time I run this rather than having to paste the path

Do you think there's any way to tweak this?

Please Login or Register  to view this content.

Thanks so much for the help!