Configuration option for SAS® Add-In for Microsoft Office functions like autoexec


Beginning with SAS Add-In 7.14 for Microsoft Office, the configuration option WorkspaceInitializationFile is available. This option points to a local SAS® program that executes when the SAS add-in instantiates a workspace server. It functions like an autoexec file for the SAS add-in.

To use this option, edit the SAS.OfficeAddIn.dll.config file using a plain text editor. This file is located in the SAS Add-In for Microsoft Office installation directory. Add the WorkspaceInitializationFile key, making sure to match the casing exactly. For the value attribute, enter the location and the name of the SAS program within double quotation marks.

Here is an example:

<configuration>

  <assemblySettings>

    <add key="WorkspaceInitializationFile" value="C:\public\samples\AMOAuto.sas"/>

  </assemblySettings>

</configuration>