6 Replies Latest reply: Oct 30, 2012 5:10 AM by Lav Jain RSS

    export to excel not working in axis point

    sriram s



      I have created a button and written a macro for exporting a table and chart to excel as per the requirement .It works properly in local system.But when I publish the report in axis  point I could not able to see the button  and export to excel feature.


      I am using IE (internet explorer) for viewing the reports.


      Below is the macro which I have used for export to excel function


      sub ExportBitmapExcel2

      Set XLApp = CreateObject("Excel.Application")
      XLApp.Visible = TRUE
      Set XLDoc = XLApp.Workbooks.Add

      j = "Sheet1"


      XLDoc.Sheets(j).Range("A" & 17).Select

      ActiveDocument.GetSheetObject("CH638").CopyTableToClipboard true

      XLDoc.Sheets(j).Range("A" & 37).Select

      ActiveDocument.GetSheetObject("CH652").CopyTableToClipboard true

      XLDoc.Sheets(j).Range("A" & 57).Select

      end sub



      Can anyone help me how to resolve the issue when I publish the report in the axis point .