Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
saumyashah90
Specialist
Specialist

Add Disclaimer while exporting to excel

When someone clicks on an export to excel an disclaimer should come.

is it possible?

5 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Maybe with a macro it could be possible, but then you have to export with a button ....

hope it helps

its_anandrjs

Hi,

You have to use Macros for this and with any text object to pass the disclaimer and put into the macro code.

Regards

Anand

saumyashah90
Specialist
Specialist
Author

okay i think macro wont work in Ajax client

so atleast if you guyz have any idea

like when we click on XL -> it exports table to excel

something would be happening at the backend ,somewhere from where i can know like some action took place?

saumyashah90
Specialist
Specialist
Author

okay i think macro wont work in Ajax client

so atleast if you guyz have any idea

like when we click on XL -> it exports table to excel

something would be happening at the backend ,somewhere from where i can know like some action took place?

alexandros17
Partner - Champion III
Partner - Champion III

Object like tables or graph do not listen any action so it is not possible to trigger an event as you desire.

You're right with Ajax but it is not a general rule becouse some macros works,

here it is the one to export data (not a disclaimer)

SUB EXPORT_Percentage
set sObject1 = ActiveDocument.GetSheetObject("CH_EXPORT")
set v = ActiveDocument.GetVariable("vOggi")

sObject1.ExportBiff "E:\qlik\Accounting\Excel\" & v.GetContent.String & "_Daily_Summary_Export.xls"
end sub