Macro not working

Mon, 14 Oct 2013 09:12:49 GMT

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.

Re: Macro not working

bbi_mba_76 — Mon, 14 Oct 2013 09:32:10 GMT

Hi,

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

Re: Macro not working

Mon, 14 Oct 2013 09:36:13 GMT

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

topic Re: Macro not working in QlikView

Macro not working

Re: Macro not working

Re: Macro not working