Skip to Content
0

Simple Macro Question

Aug 28, 2017 at 05:12 AM

26

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers