Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ssriramin19
Contributor III
Contributor III

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

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

View solution in original post

6 Replies
ssriramin19
Contributor III
Contributor III
Author

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

Not applicable

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
Contributor III
Contributor III
Author

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

have u done what i've posted?

ssriramin19
Contributor III
Contributor III
Author

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

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