Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner - Master
Partner - Master

Export Excel in AJAX

Hi

In my project for security reason we have uncheck the option to export and print in the qmc, but we have only for 2 user that they can export and print only some objects (not all the object in the document)

I implement some code using macro, but this doesnt work in ajax(only in ieplugin) is there any way to do this using fullbrowser(ajax)

thank you, i will appreciate all the help

Fernando

3 Replies
vlad_komarov
Partner - Specialist III
Partner - Specialist III

Fernando,

This code should work on Ajax (exporting specific chart to the file):

Sub PAExportMem

ActiveDocument.ShowPopup "Please wait...export may take several minutes. File will be saved to Exports folder.", 200

fileVar = ActiveDocument.Variables("vFilenameMem").GetContent.String

fileVar2 = "O:\data_ex\" & fileVar & ".xls"

set objExport = ActiveDocument.GetSheetObject("CH02")

objExport.ExportBiff fileVar2

objExport.ExportEx fileVar2,5

ActiveDocument.GetApplication.MsgBox("Chart Export Completed!")

End sub

juleshartley
Specialist
Specialist

How does this work on Ajax?...

vlad_komarov
Partner - Specialist III
Partner - Specialist III

Julia,

It works fine in several applications I've developed.
Why you asking?

VK