Creating Macros for Microsoft Document Events

Several events exist for Microsoft documents when users have installed Accolade Office Extensions. Administrators and Process Designers can write macros that these events call to add additional functionality to respond to the events.

Using these macros requires that you create a module named SGMEvents in the document.

• SGMRefreshStarted - Called after the Refresh Data From Server command has been clicked.

Public Sub SGMRefreshStarted ()

• SGMRefreshComplete - Called after all tables and charts have been refreshed.

Public Sub SGMRefreshComplete()

• SGMTableRefreshStarted - Called after user clicks Save after modifying a table.

Public Sub SGMTableRefreshStarted (Optional sTableRangeName as string)

• SGMTableRefreshComplete - Called after a single table is refreshed. And called again after all tables are refreshed.

Public Sub SGMTableRefreshComplete (Optional sTableRangeName As String)