How to click OK in excel pop up


#1

Hello. I have created a simple workflow where I open Excel and run a macro. The macro give me a message box and tell me to click ok. What is the best way to automate the “OK-clicking”?


#2

A. If possible disable the MessageBox pop up in the VBA (absolutely pointless for an automated process).

B. You can use simple UI to physically click the Message Box OK button.

C. If the above fails, try sending a hotkey of Enter to the messagebox specifically.


#3

Thank you. I will look into your suggestions.