Forum Discussion
Help needed with automatically importing and transposing data into a table from a series of files.
Bunnytree I would suggest you learn a bit about PowerQuery (PQ). It has built-in functionality to connect to files in folders (including sub-folders). How exactly is a bit difficult to describe in a few words and you may not find it very easy in the beginning, but once you get to know it a little, you'll love it. And, I dare to say it will be easier to learn and maintain than a VBA solution.
The link below would be a good starting point. Chapter 9 (scroll down a bit) deals with importing files from a folder.
Bunnytree I would suggest you learn a bit about PowerQuery (PQ). It has built-in functionality to connect to files in folders (including sub-folders). How exactly is a bit difficult to describe in a few words and you may not find it very easy in the beginning, but once you get to know it a little, you'll love it. And, I dare to say it will be easier to learn and maintain than a VBA solution.
The link below would be a good starting point. Chapter 9 (scroll down a bit) deals with importing files from a folder.