Disabling message boxes in automation tool

[Neil1988]

Hi all,

I have a tool 'WRAPPER' which opens other target workbooks, updates inputs and runs existing macros within them.

WRAPPER can also apply loops, running the same target workbook and macros multiple times for different sets of inputs. WRAPPER works great in most cases, but struggles when there is a message box in the macro called in the target workbook as it will pause at this message box until the user intervenes and clicks 'ok' - this prevents automatic looping to run the target workbook multiple times for different sets of inputs.

In the above I'm referring specifically to message boxes created by the target workbook's VBA, and not other pop-ups which I know how to disable. Short of removing the lines of code creating the message boxes from the target workbook, does anyone have any ideas on how to work around this?

Thanks,

Neil





I have a tool which opens other Excel workbooks, updates inputs and then runs exist macros within them. It can also apply loops,

 

[severynm]

Hi,

Not that I know of - your only other option might be to duplicate the code (minus the message boxes) in your script.

 

[Neil1988]

Thanks

Hi,

Not that I know of - your only other option might be to duplicate the code (minus the message boxes) in your script.

Thanks, like you say I doubt there is an easy solution to this one. Duplicating code isn't an option as WRAPPER is intended to be generic and work with any underlying workbook - the only problem we've found with it so far is the message pop-ups, which in the medium term can be removed from the underlying workbooks and, in cases where the messages are important, written to a log instead.