Infor EPM Excel Add In - Calculation reports via VBA

Hallo Community,

We have an Excel report (Infor.Get.Value - Formulas) that we want to calculate and print out for a list of cost centers one after the other. 
Classic batch print. 
Unfortunately, recalculating the Infor formulas via VBA coding does not work properly. 
Neither the classic .calculate for ActiveSheet or ActiveWorkbook nor the keyboard shortcuts for the Infor calculation functions (Shift/Alt/R).
We have already tried the Wait function and a DoEvents loop, all without success.

Does anyone have a hint?
Oh, I realize that it would be much easier on the web, but the customer would like to do it in Excel... :-)

Thank you in advance,
Jörn

Find more posts tagged with

Infor EPM Discussions

Comments

martin-brueckel

Generally it is recommended to use 'CalculateFullRebuild'.

I remember a similar discussion, could be it helps:
community.infor.com/.../excel-integration-vba-script-wait-until-re--calculation-is-finished

Vit Holy

Hello Jorn,

is that automation of certain report printing (i.e. user signs in and triggers that) or whole process automation (i.e opening reports, signing in, calculating and printing)?

The later is probably very hard to do, if not impossible. The first should be possible although not that easy as in the past. What exactly does not work? Calculation or waiting for the calculation to be finished?

BR, Vit

unknown

Hi Vit,

I am talking about option 1.

If I write a cost center in the Excel cell in the header of the Infor.Get.Value report via VBA and then have the report recalculated via the SendKeys function, then it works perfectly.
However, if I implement a loop so that a list of cost centers is adopted one after the other, the recalculation unfortunately no longer works.

Best regards,
Jörn

0911060553270289.pdf

Vit Holy

Hello again,

please raise it to our support and indicate I have asked you to do so. Share with us the report with VBA (and ideally also DB). I'll check once I am back from PTO, cause this scenario would be super useful for other customers and we can prepare some KBA about it. Thanks!

KR, Vit

Copyright © 2025 Infor. All rights reserved.