Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

The SAS® Add-In for Microsoft Office log records information about queries generated via the SAS Add-ins for Office applications, such as the SAS Financial Management Add-In for Microsoft Excel.

The SAS Add-In for Microsoft Office (AMO) log is useful for diagnosing instances of unexpected behavior when using Microsoft Office applications to generate SAS reports.

By default, the log output is directed to an on-screen dialog box. To automatically direct this output to a file, do the following:

For SAS Financial Management releases prior to 5.2:

1. In the <SAS.OfficeAddin.dll.config> file, set the value of the statement

   <add key="ShowMessageLog" value=...>

   to "false"/.

   You might also need to set

   <add key="DocumentLoggingEnabled" value=...>

   to "false"/ to keep the log window from displaying when you invoke Microsoft Office products.
   
   

   Please note that the default location for the <SAS.OfficeAddin.dll.config> file is:

   For SAS Financial Management release 4.x:
        <<drive>:\Program Files\SAS\Add-In for Microsoft Office\>

   For SAS Financial Management release 5.1:
        <<drive>:\Program Files\SAS\Add-InforMicrosoftOffice\>

   on the client machine.




2. Add the following statement to the <SAS.OfficeAddin.dll.config> file

   <add key="LogToExternalFile" value="true"/>

For SAS Financial Management releases 5.2 and later:

Make the following changes to your <SAS.Solutions.OfficeAddin.dll.config> file:

1. Set the value of the statement

   <add key="ShowMessageLog" value=...>

   to "false"/.


2. Set the value of the statement

   <add key="LogToExternalFile" value=...>

   to "true"/.

Please note that the default location for the <SAS.Solutions.OfficeAddin.dll.config> file is:

<drive>:\Program Files\SAS\SASSolutionsServicesAdd-InforMicrosoftOffice\5.x

on the client machine.

Your output is directed to a directory similar to:

For SAS Financial Management releases prior to 5.2:
<<drive:>\Documents and Settings\<userid>\Local Settings\Temp\1\messages_xx.txt>

For SAS Financial Management releases 5.2 and later:
<<drive:>\Users\<userid>\AppData\Local\Temp\1\MessageLogFile_xx.txt>

For additional information about enabling the AMO log, please refer to SAS Note 19846.

Operating System and Release Information