Skip to Content
0
Aug 28, 2017 at 05:12 AM

Simple Macro Question

54 Views

Hello, I have a simple macro question. I am trying to refresh a report using this code. I already made sure FPMXLClient is checked in references. Here is the code, when I try to run it it gives an error.

Dim EPMobject As New FPMXLClient.EPMAddInAutomation

Sub Test()

EPMobject.RefreshActiveSheet

End Sub

The error i get is Complie Error: Invalid Outside Procedure.

Please advise. thanks.