I'm using Excel to print out documents in Word. Each time, I create an object wordApp and an object wordDoc. wordApp is new each time and wordDoc is one of a number of templates. The wordDoc bit is not a problem as they are closed each time when their purpose has been served. If the program runs to completion there's no problem but . . . .
I now want the ability to interrupt, edit the word doc and then continue. Getting tricky coz I end up with far too many instances of Word running (I don't want to bother users with having to close the app).
So, instead of creating a new version of wordApp each time, is there a way of finding an existing instance running on the PC, hi-jack it, use it for my nefarious ends then release it back to whatever the user wants to do with it.
Hope this makes sense, if not, ask and I'll write a novel about it.
PS: Apologies to GCHQ for wasting your time, only used the term hi-jack 'coz I couldn't think of another way of putting it.