Create a button to export chart to excel in AJAX

[#1]

Hi,

How do I replicate the behaviour of the XL button top right hand corner of a chart object into a nice big button that the users cannot miss? The app will have to be public web facing and AJAX so I would imagine I would be limited with Macros. I can print via actions but not export to excel, very frustrating?

TIA,

Jane

[#2]

I would like to know this too! Insight would be appreciated.

[#3]

Hello,

i have actually the same problem.

Did you find a solution ?

Kindly,

[#4]

Sorry, no solution.

Jane [:'(]

[#5]

Hi,

sub SendToExcel(UID)

set obj=ActiveDocument.getSheetObject(UID)

obj.SendToExcel

end sub

where UID is the ID of the Object you want to ewport to Excel

Hope this help 🙂

HD

[#6]

Hello Hannen,

your solution only works if using IE Pluggin, but not with Ajax.

Thank you anyway ;-))

[#7]

Hi,

Within the button action items you can chose to either save to a clipboard and then paste into Excel, or save to a csv file which could be opened in Excel ...

Not 100% sure about using that with the Ajax version, but it's not using a macro so hopefully should be ok.

Cheers,

Emma

[#8]

Anyone find a solution to this?

[#9]

I have the same requiremnent , so if anyone has a solution to this problem i would very much appreciate if you could share it with me.

Thanks

Graham