I have tested on QV 11 and seems to work Ok.
Here is our Macro
Set st = ActiveDocument.GetSheetObject(ActiveDocument.Variables("vExportSheet").GetContent().String)
st.ServerSideExportEx ActiveDocument.Variables("vQlikviewPath").GetContent().String & ActiveDocument.Variables("vFileName").GetContent().String , ";", 5
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: let vFileName='D-'&Replace(Replace(Now(),'/','-'),':','-')&'.xls';
I hope this helps.
Thanks for the reply and sample code. Did you try to export the object to csv file?
I don't have problems exporting the objects to xml, html and xls but when i try to export it on CSV the code doesn't work on AJAX/Access Point.
Below is the code I'm using:
set graphObject = ActiveDocument.GetSheetObject("TB01")
Kindly help check if this code works for you.
Well, I confirmed that the text file export does not work for .txt or .csv using parameter 1 at the end.
I have confirm that is works with 3 and 5 (XML and XLS) formats.
What is wrong with Qlikview about taking away functionality that works in QV 10???
I have alerted our VAR about this but don't know if there is any resolution. We are now trying to see if we can import data with XML instead of csv format.
Maybe you can complain as well.