This video demonstrates how to embed and run any macro automatically on rebuild by utilising the macro feature: Automatically Run Macro On Rebuild - YouTube
There are 2 examples demonstrated in the video:
- Build Number Note which is incremented on any rebuild
- General table linked to external Excel and CSV file and updated automatically
Follow the links in the description of the video for more information.