Hello everyone,
I am fairly new to SAP scripting, but have some experience with VBA already. i have the following issue trying to automate a process in SAP for my current position. So i am recording a series of procedures, pasting the code in a macro sheet and make the Excell read the VBS code with the following commands:
Dim SapGuiAuto AsObject
Dim Application AsObject
Dim Connection AsObject
Dim Session AsObject
Set SapGuiAuto = GetObject("SAPGUI")
Set Application = SapGuiAuto.GetScriptingEngine
Set Connection = Application.Children(0)
Set Session = Connection.Children(0)
So all is fine, but for one of the parts SAP makes a lot of calculations which takes a few minutes and around the middle of it, Excel generate the message:

So i have to click OK in order to continue, which is annoying because then it pops-up non-stop and i have to do it like 10-15 times in order to reach the goal, which removes the point of automation. When doing it without a macro, SAP does not give me any error. I tried turning it off with
Application.DisplayAlerts = False, but it would not works, instead gives me:

I searched the net and the site, but there was barely any usefull info maybe because my question is to specific. Some additional info:
1. My laptop is from work and i cannot install any additional software or updates to it without permission so please give me alternative solutions if you had that in mind.
2.I tried checking the Excel option for DDE, but it only gives me an error when i try to run the script:

3. Excel is 2013, SAP -ABAB.
So, can anyone help me achieve one of the three solutions i can think of:
1. Disable the pop up for OLE
2. Make it automatically click OK every time it apears
3. make Excel freeze and wait while SAP does its thing? (don't know if that makes sense..) - BTW, Tried with Application.Wait, but without success
I really hope someone can help me out here,
Thank you in advance,
Mihail