I have a macro that dynamically adjusts the columns (expressions) for an existing chart, depending on the input data. The document calculates the costs of common work and is designed so that when new ones are added or old ones removed then I dont need to change the document as it is self adjusting.
The document is called for reloading using a remote procedure call using the '/r' switch. At the end of the script, the macro should run (using references to ActiveDocument) and then the document should be saved.
Although the macro works OK when run manually (through a button) when it is attached as the 'OnPostReload' trigger, nothing seems to happen. Does 'OnPostReload' occur after the document is saved? Or is the problem with the references to ActiveDocument (which can no longer be referenced by macros called within the script)?