Thank you for the extra detailed code.

There were no repeat file names or illegal file names. I used the same sample data to test and screen record. There must be something odd with my computer not running it if it worked on your computer. I will test on windows in the office and report back - that might be the issue (currently testing on Mac (and remembering to change file path to / from \))

The longer code also didn't seem to register on my mac. Running macro just did nothing. Didn't run an error or anything. Hopefully the shorter version will work on windows, if not I will try this out.

Thanks for your help so far - much appreciated.