Excel - VBA: want to split a folder with large number of files : I am in a strange situation... I get a large number of files (XML or Excel)... I store it in a folder.

But, I need to split it into smaller batches and give it to my team members, so that they can work on those files.

So, I want to create a Macro that can split the folder (for example 1000 files) into about 10 folders with 100 files in each of them.

Is this possible? could you please guide me.

Thanks,