export to excel

[#1]

Hi ,

Not able to export to excel in the access point.Any one can help me on this

I have done this using the macro it is working fine at the tool level .But the same is not working when i am trying to export in the Access point. Is there any specific setting has to be changed.

Please advice.

Regards,

XXX

Regards,XXX

[manishkumar75]

Can u plz share the code which you have written in Macro ?

[#3]

Sub xl

set

XLApp = CreateObject("Excel.Application")

XLApp.Visible=True

set XLDoc = XLApp.Workbooks.Add

set

table = ActiveDocument.GetSheetObject("CH27")

set

XLSheet = XLDoc.Worksheets("Sheet1")

table.CopyTableToClipboard

true

XLSheet.Paste XLSheet.Range( "A1"

)

End

Sub

It is working fine at application but not working at the deployment and is there any idea how tio export the graph in to excel ???

[#4]

Hi

Do you have

Requested Module Security set to "System Access"

and

Current Local security set to "Allow System Access"

Anders

[manishkumar75]

For exporting the graph in to excel , do you mean exporting the Graph Image to Excel. If it is so then the code is as below :-

Sub

ExportDetails()

Dim

kost

Set

XLApp = CreateObject("Excel.Application"

)

TRUE

Set

XLDoc = XLApp.Workbooks.Add

""

"Sheet1"

"CH02"

).CopyBitmapToClipboard

'Copy the charts value

"A"

& 1).

Select

"CH03"

).CopyBitmapToClipboard 'Copy the charts value

"A"

& 12).

Select

End

Sub

[#6]

Thanks Manish,

Macros are not working. Yes Security is choosen as System Access and Allow System Acess in the Edit Module Section.

I am struggling with this as the macros are working fine in the Server in the Tool . When it is deployed and when u are trying to run the macro it is not working. And throwing error as well.

I am trying to run the Macro through the Button.

Can any one help me on this.

Regards,XXX

[manishkumar75]

One suggestion I want to give is to use the "Send To Excel" feature of QlikView. It works fine in all cases.

[#8]

Thanks manish,

That is working fine. Now i have changed the logic to export the charts to ppt and send it as a mail. Again the same issue it is working fine with the tool. But in Java or Ajax Clients it is not working.

Is it the BUG? or is there any specific Settings has to be enabled so that the macros will work..........

Waiting for Updates?

And is there any documents which will give the know issues in Qlik View??????????

Regards,

XXX

[#9]

Hi,

Finally i got some solution for macros. It is working with IE Plugins.

Regards,XXX

[manishkumar75]

Hi,

Can you please share the solution for Macros ?

- Manish