Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Macro not working

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.

Tags (1)
2 Replies
bbi_mba_76
Valued Contributor

Re: Macro not working

Hi,

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

Not applicable

Re: Macro not working

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

Community Browser