Office Plus

I am using VBA to run Office Plus reports (mainly CELL.GETC formulas) for multiple companies. Office Plus plugin for Microsoft Excel
Version 11.0.0.320.

Problem: The Office Plus formulas do not calculate until the procedure ends. I have tried application.calculate, etc. to no avail. How can I 'force' the cell.getc formulas to calculate?

Kind regards

Paul

Find more posts tagged with

Infor EPM Discussions

Comments

Vit Holy

Hello Paul,

you cannot use pure VBA functions to calculate but Office Plus specific API (you need to reference appropriate library):

Hope it helps!

Vit

unknown

Thanks Vit

I located the API and was able to access it.

Do you perhaps have sample code you could share for accessing the CalculateAllReports or CalculateReport functions.

Kind regards

Paul

Vit Holy

Hello Paul,

here it goes (just quickly written):

Sub calcReports()
Dim repH As AXLCLib.reportHandler
If repH Is Nothing Then
Set repH = New AXLCLib.reportHandler
End If
repH.CalculateAllReports
End Sub

Sub calcReport(reportName As String)
Dim repH As AXLCLib.reportHandler
If repH Is Nothing Then
Set repH = New AXLCLib.reportHandler
End If
repH.CalculateReport (reportName)
End Sub

Sub calcActiveReport()
calcReport (ActiveWorkbook.FullName)
End Sub

HTH,

unknown

Thanks Vit.

The code works, but the report still only calculates after the procedure has completed. for example if I put a breakpoint on the End Sub line, the report does not reflect any values. The figures only display after the procedure is allowed to finish.

When I am running multiple workbooks, they are saved with no values. So I still have to go calculate each workbook individually.

Kind regards

Paul

Copyright © 2025 Infor. All rights reserved.