I would like to export multiple objects to an Excelfile.
I have tried ServerSideExportEX with mode = 5 and Append = 1. But it does not work as I expected.
set tb1 = ActiveDocument.GetSheetObject("LB_DUMMY_1")
tb1.ServerSideExportEx strPath, ";" ,5,65001
'Append second objekt
set tb2 = ActiveDocument.GetSheetObject("LB_DUMMY_2")
tb2.ServerSideExportEx strPath, ";" , 5,65001,1
But only the last object (LB_DUMMY_2) can be found in the file , my guess is that it overwrites the file for the second call to ServerSideExportEx.
Same problem exists for export XML.
A WAD or bug?
If we export to text it works fine with append.
Version 11 SR2