Run calculation from VBA without any warnings

[Anonymous]

Hi,

I'm working on a VBA code in Excel that has to run multiple calculations in Robot, updating some parameters at each iteration.

The problem is, at every iteration I get some warnings in Robot like "This is changing the structure, results will be outdated", or "Separated structure, do you want to continue" (this is the approximate translation of the messages as myy version is not in english).

These warnings are blocking the execution and I have to click on them each time to continue.

Is there a way of not showing these so the calculation can run on itself ?

I'm still testing the boolean out of calcengine.calculate to find out if there were errors.

Thanks,

Regards.

[StefanoPasquini6790 · Accepted solution]

HI,

try to disable the warnings in the job preferences, as shown in the picture below:

Managing in this settings I'm sure that you can solve your issue.

Let me know if it work.

Hope I help you, Greetings

[Anonymous]

Thanks, it actually worked for the warnings.

Regarding the issue of the "outdated results" warning, I found the solution myself with these lines :

robApp.Project.CalcEngine.AutoFreezeResults = False
robApp.Project.Structure.ResultsFreeze = False

Regards.