Ok, the code is now working nicely, and I've trimmed all the excess out of it. I'll include a sample spreadsheet for anyone who wants to look at it down the track.
I changed the Wait to Sleep which can work in milliseconds, and to do that I needed to put at the top of the module:
I had used that years ago for something else that needed to be paused.
So the code to run the jpg creation now looks like this, with a 300 millisecond pause (at 250 I still get the odd 1004 crash)
I imagine that the 300ms delay is directly related to the type of disc drive that the jpgs are being written too. In my case it's a med-high speed Samsung SSD which I think has a max write speed of about 400MB/s. One of those new fangled 5GB/s drives might only need around 50ms.
Or maybe the delay is required for some other part of the process....
NOTE: For anyone who wants to run the two macros in the book, press the blue oval "Make new Folders" first and that will create the required folders inside a root folder "1. Music" on your C drive.
Then press blue oval "MUSO" and it will run through and create the jpgs in those folders from the information in column D.
Bookmarks