Context: |
Class Property |
Library/Class: |
StaticVars Class |
StaticVars.AftWritMacr As Single, Read/Write
After Write Macro.
Name of a Word or Excel macro to be executed after each Notes document is exported to Word or Excel. The execution of the macro follows the CB_AFTERWRITECOM event. This property is exposed to the profile creator in the advanced tab of the Integra profile. However, the name of the macro can be changed dynamically at runtime.
With Integra 4.1 two new Excel export methods have been introduced, namely Normal (using CSV) and XML. These two methods avoid the use of COM technology and are therefore much faster. However, this performance improvement comes with a reduced flexibility or usability when it comes to the Integra events. The main difference between the use of COM technology and the new CSV or XML export is that the latter do not write every single exported Notes document into rows in Excel, but rather collect all rows in either CSV format or XML format (MS Office 2003+). Once all Notes documents are exported to CSV or XML, the CSV or XML file is imported into the Excel spreadsheet. The consequence of this is that the CB_AFTERWRITECOM event becomes very limited in its use, thus the After Write Macro useless in this context.
|