Automating Input during a macro....

[Centurius]

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.

 

[Don Guillett]

Perhaps you could ask the developer to customize

 

[marcus.tettmar]

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