Hi all,
Just been using Macro Express to automate some batch processing of files, and have a question for those more knowledgeable than me:
My Macro sifts through a folder-load of scripts for a CAD program. Each script plots the required points in the CAD program, then saves out a finished ".dwg" file to another folder.
But I'm having trouble implementing a "smart" way to get MacroExpress to wait for the CAD program before looping back through the folder.
I tried using "Wait File Exist", but so far as I can see, you have to specify the precise filename if you're going to use that command. In other words, you can only make it look for a specific file, not one that varies on each pass through the loop.
So I think I need a way of specifying the file as a mix of text and string (the string being the same as the name of the original script that's running for this particular pass throught the loop). Is there a way to do this?
At the moment, I've fallen back on just sticking a big "wait time delay" into the macro to make sure the CAD program's had time to do it's thing, but that's neither elegant nor time-efficient, and I can only get away with it because at the moment the individual CAD scripts are small and complete in under a minute. I've got another batch to do fairly soon that will take varying periods of time, and I've no way of second-guessing how long each one might take, so this method won't work unless I allow a stupidly long time delay.
Any bright ideas gratefully accepted!
Cheers,
Minmi