Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export to excel

Hello,

How can i export the object data to excel file at access point.

Is there possiblity to expoet to excel file at access point through any type i.e either with macro code also enough for me.

5 Replies
Not applicable
Author

When i check option to send to excel file. It is working fine but when i use to export the excel file with macro code it is not working..

Sub ExportImageInfo

Set Chart = ActiveDocument.GetSheetObject("CH396")

Set P = Chart.GetProperties

Chart.SendToExcel

End Sub

m_woolf
Master II
Master II

I don't see anything wrong with your code.

Do you really have a chart with ID CH396?

Do you get an error?

Not applicable
Author

Thanks to respond me...

I've particular ID with object. It is working fine at desktop.

Sorry for late response.

m_woolf
Master II
Master II

Are you using the IE Plugin or Ajax?

If using the IE plugin, do you have macro security set to System Access? Shift+Ctrl+M

Not applicable
Author

Ya i've already given it..

One more functionality also not working at ASP.

I'm creating BM through macro code with button action.

Button 1 action:

sub BM1

            ActiveDocument.RemoveDocBookmark "BM01"

    ActiveDocument.CreateDocBookmark false, "BM01"

end sub


This code is working fine at desktop and access point.

To retrive the created BM i'm using below code in another button.

sub BM2

  ActiveDocument.ClearAll false

  ActiveDocument.RecallDocBookmark "BM01"

end sub

This code is working fine at desktop but not at access point

How can i apply created BM at ASP.

Please give a way for this. B'coz it is very urgent for me.

I've tried almost all codes which are there in API guide. But it is not working.