SAS® Add-In for Microsoft Office configuration option to submit code when server is connected


Beginning with SAS Add-In 7.14 for Microsoft Office, a configuration option is available that executes a local SAS® program when a workspace server is instantiated by the SAS add-in.

To use the option, edit the SAS.OfficeAddIn.dll.config file in the SAS Add-In for Microsoft Office installation directory in a text editor. Add the key "WorkspaceInitializationFile". The key value is the path and name of the local SAS program file on the same machine as the SAS Add-In for Microsoft Office. Here is an example file:

<configuration>
<assemblySettings>
<add key="WorkspaceInitializationFile" value="C:\temp\AMOAuto.sas" />
</assemblySettings>
</configuration>