2 Replies Latest reply: Oct 14, 2013 5:36 AM by Hannan Tariq RSS

    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.