I know there's dozens of threads on here about how to pause a macro for
user input, but i want to go the other way... just to be difficult.

I'm putting together a switchboard of sorts to monitor all current jobs
going through at work. It is going to open our CAD drawings (in
autocad), Quotes (in Micro$oft word), and jobcosting (in Excel)... the
drawings and quotes are easy as... the tricky bit comes in the
jobcosts... we use a program built by a local guy as a plugin type
thing for Excel, with many many macros that not only could i not
understand, but i can't get access to in the first place.

What i want to do, is open the XL spreadsheet that runs all his
macrosloads toolbars etc (which i've done), then run the macro for
opening an existing job (which i've done) and insert the jobname (from
my original switchboard spreadsheet) into the open file dialog when it
pops up midway through the developers macro.

If it were as simple as opening a spreadsheet it would be a cinch, but
the way the jobcosts are stored, the developers macro decodes and
reconstructs all the data stored in the spreadsheet. so i need to
automate the jobname from the cellvalue in my switchboard.

Hope someone out there can help... i can't seem to find how to put this
in when the macro pauses, without having access to the VBA that is
running.