Skip to Content
0
Former Member
Jan 28, 2014 at 12:13 PM

7.5 schedule in EPM 10

21 Views

In my 7.5 workbook after submit macro we monitor the events to capture the save complete before we proceed with next action like expand or refresh .

But that code in EPM is throwing an error saying can't run macro and mayn't be available. What is the equivalent code for EPM?

Set oExcel = Application.Run("GetEvents")

Full code looks like this

myWB.SaveWorkbookData

Dim oExcel As Object

'wait for the event from the server to know that send completed

Set oExcel = Application.Run("GetEvents")

Do

DoEvents

Sleep 100

Loop While oExcel.SendResult_Status = False And oExcel.SendResult_Submitted <> -1

myWB.RefreshActiveSheet