Centurius wrote:
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.

Obviously the best solution is to customise the code. But if that is
not possible, or not something you are prepared to do, one solution
open to you is to use a third party macro tool which could retrieve the
information from the source spreadsheet and send it into the open file
dialog when it pops up. You could do this with a tool such as our
Macro Scheduler:

http://www.mjtnet.com/macro_scheduler.htm

Marcus
http://www.mjtnet.com
Macro Scheduler for Windows and Software Process Automation