It's weird because I tried it on a different machine and it opens all the word docs at once. It has to be some kind of Windows setting or something in Office. Haven't been able to figure it out yet. Otherwise, this has the potential to work nicely.
Getting the last file name off of %Tn% seemed like it would work well too but for some reason or another, even though I tell it to wait until the last file name title appears, it keeps moving on after about 35 files. Go figure?????
To answer your question, basically, the main Macro does this:
Checks a folder every few seconds to see if Word Docs have been added.
If so, it takes the Word Docs and moves it to another folder for processing.
Open all Word Docs (seems to be more efficient as far as time is concerned)
Take a Word Doc, correct a Margin Discrepency, save as a PDF to a shared directory, save as a TIFF to another shared directory, resave Word Doc with corrected margin and place in another shared directory. Thus it creates a PDF, TIFF and an updated DOC for each file and saves them to a shared directory that users can access.
Move on to the next Word doc for processing until all have been completed.
Check the main folder again for more docs. If not, wait five seconds and check again.
Macro set to start everyday at 6:00 and shut down at 20:00
There are other things it does on the side but basically the above is its main task. The tricky part is it needs to run everyday and mostly unattended so I had to work in many scenarios where it bombs out so that it can get itself out of it and restart. Has been a challenge but when it works it's pretty sweet. Files can get dumped in the folder as little as a few per minute upwards to 50 per minute so on peak times it is a pretty busy macro.
Thanks for all your help on this Cory. Much appreciated!