Excel Add-in and VBA Code

image_pdfimage_print

To receive no extended computing time, your VBA_code should include the red lines:

Sub VBA_code()
On Error GoTo Cleanup ‘ <- new
Excel.Application.EnableEvents = False ‘ <- new

<Your VBA code>
Cleanup: ‘ <- new
    Excel.Application.EnableEvents = True ‘ <- new
End Sub

If you use

PALO.DATAC() or PALO.DATAX()

in your Excel file, then you should use

Application.Run(“PALO.CALCSHEET”)

instead of

ActiveSheet.Calculate

in the VBA code.

image_pdfimage_print
Was this post helpful?
NoYes (+2 rating, 2 votes)
Loading...