Macro not working

[#1]

Hey there,

I have created a MACRO for exporting the table data into excel file. I have tested it by applying Action to the button. When i click on the button the macro works fine. But I need the macro to work on the PostReload Trigger. When I apply the Run Macro Action on PostReload trigger, the macro does not work. Instead the dashboard goes to Not Reasponding state.

Can anyone tell me what could be the issue. I am sharing my macro code which is working perfectly fine for me. The Problem is in applying the PostReload Trigger.

Sub DateExportPrev

Set Var = ActiveDocument.GetVariable("vPathDate2")

'MsgBox("DataHas Been Transfered")

set obj1 =ActiveDocument.GetSheetObject("Macro2")

obj1.ExportBiff Var.GetContent.String&".xls"

End Sub

Sub DateExport

Set Var = ActiveDocument.GetVariable("vPathDate")

'MsgBox("DataHas Been Transfered")

set obj1 =ActiveDocument.GetSheetObject("Macro1")

obj1.ExportBiff Var.GetContent.String&".xls"

End Sub

Two Macros have been applied seperately for two tables to export data to excel.

[bbi_mba_76]

Hi,

maybe you have to wait until the objects to be exported give a result.

[#3]

I have tried this also .. waited for almost an hour to get the result but still nothing. It takes Hardly a minute to export data when I test it using button. And it is also working fine on OpenDoc Trigger. Its just not working on PostReload Trigger