topic Re: export to excel not working in axis point in QlikView

export to excel not working in axis point

ssriramin19 — Tue, 30 Oct 2012 05:50:41 GMT

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

Re: export to excel not working in axis point

ssriramin19 — Tue, 30 Oct 2012 08:15:37 GMT

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

Re: export to excel not working in axis point

Tue, 30 Oct 2012 08:20:10 GMT

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!!!

Re: export to excel not working in axis point

ssriramin19 — Tue, 30 Oct 2012 08:39:54 GMT

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

Re: export to excel not working in axis point

Tue, 30 Oct 2012 08:40:43 GMT

have u done what i've posted?

Re: export to excel not working in axis point

ssriramin19 — Tue, 30 Oct 2012 08:59:13 GMT

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

Re: export to excel not working in axis point

Tue, 30 Oct 2012 09:09:50 GMT

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