macro to copy files from one folder to another RANDOMLY

[eliW]

Hi All,
I have files in one folder and want to copy paste them to another folder in random order.
I'll appreciate very much any advise to do it automatically by a macro.
Thank you,
Eli

 

[Rijnsent]

Hi Eli,
Step 1: list files in an array (accepted solution): https://stackoverflow.com/questions/31414106/get-list-of-excel-files-in-a-folder-using-vba
Step 2: shuffle array: http://www.cpearson.com/excel/ShuffleArray.aspx
Step 3: loop array and copy-paste files
Cheers,
Koen

 

[eliW]

Hi Koen,
Thank you for your answer.
Unfortunately the links you suggested dosen't help me much as I cannot find the exact scripts to use in my macro.
I agree that my question can be simplified to 3 steps:
1. Choosing folder1 and listing all files in that folder to first column in a worksheet (including path)
2. Shuffling the list (I can doit manually)
3. Copying each file (according to the list) from folder1 to folder2
I need more help to do this.
Thank you again,
Eli