Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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