You are welcome to write your own macros to help populate your data sheets. The data sheets may be in the Wizard workbook or even in separate workbooks.
The only constraint is you may not store your macros in the Wizard workbook as this is protected. However, it is a simple matter to store these in a separate workbook.
To assist with automating your custom application, we have provided some APIs.
Budget Wizard can be saved as an XLA (Excel Addin) and any spreadsheet can invoke the ribbons and the API procedures.
This workbook contains sample procedures showing how you can use Budget Wizard as an engine to upload and download from/into sheets you pass as parameters to the procedures.
As a bonus, we have provided an extremely useful API you can use to run any select SQL statement against your database, returning the results in a Variant array. (For safety reasons only ‘select’ statements are allowed).
