Adding text while exporting objects using "send to excel"
Hi,
Is there a way to add some fixed text (e.g. adding the text "For Internal Use only") to be added to any excel file exported using "Send to Excel object" from a particular QV application. In other words, the QV application has multiple chart objects and I want to ensure that the text is added whenever any of the chart objects are exported to excel.
Within the export-properties is an option to add the current selection-state to the exported object. If you creates an extra dimension-values (maybe as loose table) and select and locked this field it would be returned to each object.
If this don't worked how do you wish you will need a macro-routine which creates/opened an excel-file and copied and pasted multiple objects in them - have a look here on many examples:
