Macros

Macros enable you to automate a process within DataLink Server by calling exposed functions within the macro.

Before creating a macro, ensure that you have these prerequisites:

• The DataLink Server Plug-in is enabled and you are logged on.
• The option Trust access to the VBA project object model is enabled in the Trust Center of Microsoft® Office Excel.
• That the Reference has been enabled to allow interaction.

To enable the Reference within Microsoft Excel, press ALT+F11 and select Tools > References.

In References the VBAProject Window Enable should have InforQueryAndAnalysisEvolve selected.

To create a macro manually enter the appropriate VBA code into Excel's Macro Editor. The files should be stored as XLSM files, which is an Excel macro-enabled Workbook. After you have created your macro you can assign a standard Excel Button to the macro. Refer to the Microsoft Online help for further information. It is also advisable to avoid renaming the macro once created.