Home > Extensions > How to Create an Extension
How to Create an Extension
||Filename||The Add-in's filename must begin with the letters RNA-|
||Create reference to ReportsDNA||Create a reference to the ReportsDNA Add-In to enable calls to the ReportsDNA interface. This is required to set and get extension-specific report settings.|
1. In the Excel menu, click Tools | Macro | Visual Basic Editor
2. In the Microsoft Visual Basic Editor menu, click Tools | Reference
3. Check the box next to ReportsDNA
A function called by ReportsDNA to register the extension.
The extension must contain a public function named RNA_PROPERTIES that returns a Dictionary Object.
Click here for additional information.
A function that allows a user to configure report settings needed by the extension to generate the report. For example, for a database, this function may display a form that allows the user to enter the database name, user name and password.
This function is called by ReportsDNA when a user clicks on the extension name in the Source listbox.
The name of the function does NOT have to be named SHOW_CONFIG. The name is set by the extension author in the RNA_PROPERTIES function.
A function that calls ReportsDNA functions to save the extension-specific report settings. It is the function called when the user submits the report settings for the extension.
This function is NOT called by ReportsDNA. It is included here to provide a complete example of an example.
The name of the function does NOT have to be named SUBMIT_CONFIG.
A function that generates or retrieves the source data for the report.
This function is called by ReportsDNA when the user generates the report.
The name of the function does NOT have to be named GET_DATA. The name is set by the extension author in the RNA_PROPERTIES function.