Disabling message boxes in automation tool

Neil1988

New Member
Joined
Jun 23, 2021
Messages
2
Office Version
  1. 365
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,
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

severynm

Board Regular
Joined
Jan 8, 2021
Messages
220
Office Version
  1. 365
Platform
  1. Windows
Hi,

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

Neil1988

New Member
Joined
Jun 23, 2021
Messages
2
Office Version
  1. 365
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.
 

Forum statistics

Threads
1,143,620
Messages
5,719,789
Members
422,244
Latest member
AYSHANA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top