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

    export to excel not working in axis point

    sriram s

      Hello

       

      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"


      ActiveDocument.GetSheetObject("CH02").CopyBitmapToClipboard

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


      ActiveDocument.GetSheetObject("CH638").CopyTableToClipboard true

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


      ActiveDocument.GetSheetObject("CH652").CopyTableToClipboard true

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


      end sub

       

       

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

       

      Thanks