PDA

View Full Version : Solved: Check list of folder files



Sisyphus
06-05-2009, 08:52 AM
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
06-05-2009, 10:33 AM
Have a look at this (http://www.vbaexpress.com/forum/showpost.php?p=186911&postcount=3).

Sisyphus
06-05-2009, 10:52 AM
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
06-05-2009, 10:59 AM
Sorry, I initially missed your link at the top of your post. I'll take a look at it. Thanks.

Sisyphus
06-05-2009, 12:01 PM
Thanks, mdmackilltop. It doesn't get me all the way there, but I think it'll get me over the hump.

mdmackillop
06-05-2009, 12:11 PM
Just let us know if you need any assistance.