Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ssriramin19
New Contributor II

export to excel not working in axis point

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

1 Solution

Accepted Solutions
Not applicable

Re: export to excel not working in axis point

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

6 Replies
ssriramin19
New Contributor II

Re: export to excel not working in axis point

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

Not applicable

Re: export to excel not working in axis point

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
New Contributor II

Re: export to excel not working in axis point

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

Not applicable

Re: export to excel not working in axis point

have u done what i've posted?

ssriramin19
New Contributor II

Re: export to excel not working in axis point

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

Not applicable

Re: export to excel not working in axis point

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

Community Browser