Export to Excel in HTML mode

[#1]

Hello,

I have been ask by a client to enable the pivot table to be export its data to Excel.

I have used the following vbscript (part of it, the most important):

sub exportToExcel_Variant1
Dim aryExport(0,3)
aryExport(0,0) = "CH181"
aryExport(0,1) = "Data Export"
aryExport(0,2) = "A1"
aryExport(0,3) = "data"
Dim objExcelWorkbook 'as Excel.Workbook
Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)

In the the development, the button (script) works fine, the problem is when I tested in the web mode it doesnt work.

Can someone help me with this issue please?

Many thanks!!!

[Gysbert_Wassenaar]

Macro's with code like that don't work in the ajax client. The server simply cannot execute code on the client.

[#3]

Thanks for your help Gysbert,

Do you think would be better use JScript for this task?

[Gysbert_Wassenaar]

No, the server cannot execute code on the client. It does not matter if the code is vbscript or javascript.