XL Export button works in Developer client and not in server

[ksasidhars]

Hi,

I'm trying to export data using a button where I've the below script associated.

SUB SendToExcel

SET chart = ActiveDocument.GetSheetObject("CH93")

SET p = chart.GetProperties

chart.SendToExcel

END SUB

Could you please let me know why is this button exports when I try in my developer client and fails when tried from Access point. I'm able to export through Send to XL on the chart in server/Access point but not with the button. Please advise. Thanks

I've tried using the server export function as well without luck.

Regards

Sasi.

[#2]

Add  the AccessPoint  site address  as a Trusted Site in internet settings on the server

[ksasidhars]

Ganesh,

Actually there is no issue with the pop up blocker/Access settings in browser as I'm able to export by the option 'Send to XL' on the chart. If it is this reason, atleast should work when I tried with CTRL key.

Thanks anyways for your quick idea, but It still seems to be not working. Please let me know if you think there is any other settings to be done. Thanks

- Sasi

[ksasidhars]

Could anyone please share your views? Thanks

[raghavsurya]

Hi Sasi,

In Edit module where you have saved your macros, make "Requested Module Security" as "SYSTEM ACCESS" and Current Local Security as Allow system access.

Regards,

Raghav

[ksasidhars]

Thanks much for your reply Raghav. Actually I tried this option as well without success. The button is saving the XL file when I've Server side export function, but it is not opening it in XL. Don't understand whats the issue.

[erichshiino]

Hi,Sasi.

Which version are you using? Are you using IE Plugin or Ajax? I don't think it can call excel from ajax.

What happens if you click on the 'export to excel' button on the top of the chart?

Does it work if you right click and select export (and choose an excel format)?

[ksasidhars]

Hi Erich,

Thanks a lot for looking at my issue. I'm working on 11 IR desktop and IE plug in.

When I click Export to Xl, it works perfectly. Also, I use ServersideExportEx() and it saves the file in Documents directory on server.

Only issue is to open the XL by the button click. Kindly let me know if you need any clarification from my side. Thank you. - Sasi