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,
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,