The SAS Add-In for Microsoft Office (AMO) 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 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, complete the following steps:

For SAS Financial Management release 5.2 :

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

Note: Here is the default location for the SAS.Solutions.OfficeAddin.dll.config file on the client machine: your-drive:\ProgramFiles\SAS\SASSolutionsServicesAdd-InforMicrosoftOffice\5.x.

1. Set the value of the following statement to "false"/:
   <add key="ShowMessageLog" value=...>
2. Set the value of the following statement to "true"/:
   <add key="LogToExternalFile" value=...>

For SAS Financial Management releases 5.3 and later:

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

Note: Here is the default location for the SAS.Solutions.OfficeAddin.dll.config file is on the client machine: your-drive:\Program Files\SASHome\x86\SASFinancialManagementAdd-InforMicrosoftOffice\5.x.

1. Set the value of the following statement to "false"/:
   <add key="ShowMessageLog" value=...>
2. Set the value of the following statement to "true"/:
   <add key="LogToExternalFile" value=...>

Your output is directed to a directory similar to the following on the client machine:

Note that the messages_ or the MessageLogFile_ filename is incremented (the value of xx increases) each time new log information is written out to a file.

For additional information about enabling the AMO log, refer to SAS Note 19846. "How to generate the SAS^® Add-In for Microsoft Office (AMO) log with SAS Financial Management releases prior to 5.3."

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS Financial Management	Microsoft Windows 2000 Advanced Server	9.1 TS1M3
		Microsoft Windows 2000 Datacenter Server	9.1 TS1M3
		Microsoft Windows 2000 Server	9.1 TS1M3
		Microsoft Windows 2000 Professional	9.1 TS1M3
		Microsoft Windows Server 2003 Datacenter Edition	9.1 TS1M3
		Microsoft Windows Server 2003 Enterprise Edition	9.1 TS1M3
		Microsoft Windows Server 2003 Standard Edition	9.1 TS1M3
		Microsoft Windows XP Professional	9.1 TS1M3
		Windows Vista	9.1 TS1M3
		64-bit Enabled HP-UX	9.1 TS1M3

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Type:	Usage Note
Priority:

Date Modified:	2011-06-22 15:20:04
Date Created:	2009-12-07 15:31:01