topic Re: Run calculation from VBA without any warnings in Robot Structural Analysis Forum

Run calculation from VBA without any warnings

Anonymous — Thu, 19 Feb 2015 13:51:52 GMT

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.

Re: Run calculation from VBA without any warnings

StefanoPasquini6790 — Thu, 19 Feb 2015 15:34:54 GMT

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

Re: Run calculation from VBA without any warnings

Anonymous — Thu, 19 Feb 2015 15:59:27 GMT

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.