Solved: Check list of folder files

[Sisyphus]

I would like to be able to select multiple files from a list of CSV files within a folder to merge into an Excel spreadsheet. My first thought is to create a list of checkboxes, but it would have to be created each time from a target folder. I'm rather new to VBA and am not sure how to do this.

I am also open to alternative approaches.

Any help would be appreciated.

[mdmackillop]

Have a look at this.

[Sisyphus]

I'm new to this forum. Where do I attach files?

There should be around 25 or less CSV files in a given folder. Each files will have 8 columns, with the resultant combined spreadsheet up to around 700 lines or so max.

[Sisyphus]

Sorry, I initially missed your link at the top of your post. I'll take a look at it. Thanks.

[Sisyphus]

Thanks, mdmackilltop. It doesn't get me all the way there, but I think it'll get me over the hump.

[mdmackillop]

Just let us know if you need any assistance.