Problem Note 46469: "Member not found" might appear when attempting to run a task with the SAS® Add-In for Microsoft Office
When attempting to run a task with the SAS Add-In 5.1 for Microsoft Office, you might see a message similar to the following:
Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND))
Exception Details:
----------------------------------------
Exception type: System.Runtime.InteropServices.COMException
Message: Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND))
Source: mscorlib
Target Site: ForwardCallToInvokeMember
Stack Trace:
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.Range.get_CountLarge()
at SAS.OfficeAddin.ExcelDataSource.IsValidRange(Range range)
at SAS.OfficeAddin.ExcelDataSource..ctor(Range range)
at SAS.OfficeAddin.ExcelAddin.GetDataSourceForActiveSelection(Boolean lookForUnderlyingData)
at SAS.OfficeAddin.OfficeAddinBase.PromptForInputData(AMORunnableItem item)
at SAS.OfficeAddin.Task.ValidateDataSource()
at SAS.OfficeAddin.Task.PrepareTask(Boolean showDialog, Boolean delayProxyCleanup)
at SAS.OfficeAddin.Task.BeforeExecute(BeforeExecuteEventArgs e)
at SAS.OfficeAddin.OfficeAddinBase.LaunchRunnable(IRunnable job, Boolean showDialog, JobResultLocation location)
at SAS.OfficeAddin.OfficeAddinBase.LaunchFromRunnableInfo(IRunnableInfo jobInfo)
at SAS.OfficeAddin.OfficeAddinBase.OnTaskInvoked(Object sender, TaskInvokedEventArgs e)
at SAS.OfficeAddin.UIManager.OnTaskInvoked(String classId)
at SAS.OfficeAddin.RibbonManager.OnButtonClick(IRibbonControl control)
Typically, this error occurs only when running Microsoft Office 2007. To prevent this error from occurring, install SP2 for Microsoft Office 2007, which can be found at: KB970357.
Operating System and Release Information
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 5.1 | | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Standard Edition | 5.1 | | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 for x64 | 5.1 | | 9.3 TS1M0 | |
| Microsoft Windows Server 2008 | 5.1 | | 9.3 TS1M0 | |
| Microsoft Windows Server 2008 for x64 | 5.1 | | 9.3 TS1M0 | |
| Microsoft Windows XP Professional | 5.1 | | 9.3 TS1M0 | |
| Windows 7 Enterprise 32 bit | 5.1 | | 9.3 TS1M0 | |
| Windows 7 Enterprise x64 | 5.1 | | 9.3 TS1M0 | |
| Windows 7 Home Premium 32 bit | 5.1 | | 9.3 TS1M0 | |
| Windows 7 Home Premium x64 | 5.1 | | 9.3 TS1M0 | |
| Windows 7 Professional 32 bit | 5.1 | | 9.3 TS1M0 | |
| Windows 7 Professional x64 | 5.1 | | 9.3 TS1M0 | |
| Windows 7 Ultimate 32 bit | 5.1 | | 9.3 TS1M0 | |
| Windows 7 Ultimate x64 | 5.1 | | 9.3 TS1M0 | |
| Windows Vista | 5.1 | | 9.3 TS1M0 | |
| Windows Vista for x64 | 5.1 | | 9.3 TS1M0 | |
*
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: | Problem Note |
| Priority: | medium |
| Date Modified: | 2012-05-08 11:32:52 |
| Date Created: | 2012-05-02 09:51:06 |
