Sub ExportExcel Set st = ActiveDocument.GetSheetObject(ActiveDocument.Variables("vExportSheet").GetContent().String) st.ServerSideExportEx ActiveDocument.Variables("vQlikviewPath").GetContent().String & ActiveDocument.Variables("vFileName").GetContent().String , ";", 5 End Sub
The variable 'vExportSheet' contains the Chart Object Id. Example: 'SAL01'
The variable 'vQlikviewPath' contains the path to a folder on the server where the document will be stored.
Example; \\cinnamon\files_qv\ (note: the path needs to be a network path and the folder needs shared and Read/Write access. So 'cinnamon' is our Server name and 'files_qv' is the folder where the documents are stored. In this case, and Excel document.
The variable 'vFileName' is the filename.
To keep documents unique for each User on the iPad,I use this format for vFileName: letvFileName='D-'&Replace(Replace(Now(),'/','-'),':','-')&'.xls';
Our software vendor says they can import data from XML as well as csv. Since QV11 now only supports XML and XLS formats, we are good to go with QV 11 on this ServerSideExportEX function with our mobile users on iPads.