Click Ok in Message Box pop-up Excel VBA

[Mbresso]

Hi all,
I need some support, since I've created a Macro for Log-in into SAP and pull automatically some reports.
But when I'm running it, an SAP Message box pop-ups "A script is attempting to access SAP GUI" (Two Buttons: "Ok" and "Cancel") and then, after manually clic in "Ok", another message box pop-ups with "A Script is opening a connection to System: XXX" (Two BUttons: "Ok" and "Cancel").

Is there a way, in which I can Include some coding into the original Script, for advancing in those "OK" Clics so I could have the process fully automated without any manual interaction?

Thanks in advance for your guidance.

Regards

Mario

 

[Anthony47]

You could try with Application.SendKeys to send keystrokes to the active window; for example you could wait to be sure the first popup has popped-up, then send "Enter" (if Ok is already selected by default; or first send a Tab then Enter); then repeate the process for the second popup

For details about SendKeys: Application.SendKeys method (Excel)

Always insert "enough" delay from one command to the next, using either Application.Wait (example Application.Wait (Now + TimeValue("0:00:02"))) or Sleep (requires declaring the function Sub Sleep Lib "kernel32"), that has much more flexibility.

Bye