export to excel not working in axis point

[ssriramin19]

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

[ssriramin19]

Can anyone help how to resolve the above issue .This is very urgent for me.

[#3]

try :

go to ur macro and select on the left hand side in Requested module security & current local security

Select : system access & allow system access

it might work!!!

[ssriramin19]

The error I am getting is

Macro parse failed .Functionality was lost.

AciveX component can't create object 'Excel.application'

Can anyone please help me how to resolve the above error

Thanks

[#5]

have u done what i've posted?

[ssriramin19]

I have made the changes mentioned above .But I am getting the above error in axis point. But it works proper in my local machine. Only when I distribute the application I am getting the above error.

Can you help me how to resolve the above issue.

Thanks

[#7 · Accepted solution]

open QV management console

go to system tab

expand qlikview servers in management service

click ur server name and go to Security tab on the right and check the option: Allow macro excecution on server