Add Disclaimer while exporting to excel

[saumyashah90]

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

is it possible?

[alexandros17]

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]

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]

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]

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