KB11838: How to create an Excel document with Macros which run upon opening the file in Microstrategy Narrowcast Server

While Strategy Narrowcast Server does not support server-side macro execution, macros can be imported into Narrowcast Server and used as Excel templates. The macros will then be executed when the Excel file is opened. The following steps describe a basic technique of creating a macro that executes automatically when the Excel file is opened:
 

• Create a new, blank Excel document.
• Create and save the macro to be executed when the subscriber opens the Excel file.
• Edit the macro by navigating to Tools > Macro >Macros.
• Highlight the macro and click "Edit," as shown below:
  

• Locate the beginning of the subroutine:
  

• Edit the subroutine name to the following: Sub Auto_Open()
  

• Save and Close the Excel Sheet.
• Import the Excel file into Narrowcast as an Excel template.
• Edit the Service to use the new Excel sheet recently created.