VBScript: wait for Excel MsgBox, Click OK -

VBScript: wait for Excel MsgBox, Click OK -

i've written vbscript automates load of processing of excel workbooks.

for of these workbooks, msgbox triggered when opened. message box interrupting automation.

is there way hear msgbox in vbscript , "click" ok when pops up?

try utilize wrapper:

application.displayalerts = false application.workbooks.open ([your code]) application.displayalerts = true

this suppress warnings on opening, e.g. compatibility issues, etc.

update:

in case msgbox generated workbook code, seek utilize this:

application.automationsecurity = msoautomationsecurityforcedisable

in case late binding used, work:

application.automationsecurity = 3

read more: http://support.microsoft.com/kb/886633

excel vbscript automation msgbox