tomer st
Guest
|
Hi
when I perform this
Dim workBook As Excel.Workbook
workBook = ExcelApp.ActiveWorkbook
MsgBox(workBook.Name)
its works fine, but when i perform this
Dim range As Excel.Range
range = ExcelApp.Selection
range.Interior.Color = 15
I get this error
Detailed technical information follows:
---
(Inner Exception)
Date and Time: 21/01/2007 13:46:54
Machine Name: TOMER-ST
IP Address: 10.0.0.25
Current User: TOMER-ST\Tomer
Application Domain: c:\Documents and Settings\Tomer\Desktop\ExcelAddInTest\ExcelAddIn\bin\Debug\
Assembly Codebase: file:///C:/WINDOWS/assembly/GAC_32/AddinExpress.MSO.2005/2.4.1757.1__c20c070a1fc9a144/AddinExpress.MSO.2005.dll
Assembly Full Name: AddinExpress.MSO.2005, Version=2.4.1757.1, Culture=neutral, PublicKeyToken=c20c070a1fc9a144
Assembly Version: 2.4.1757.1
Assembly Build Date: 23/10/2004 00:00:02
Exception Source: Microsoft.Office.Interop.Excel
Exception Type: System.Runtime.InteropServices.COMException
Exception Message: Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
Exception Target Site: get_Selection
---- Stack Trace ----
Microsoft.Office.Interop.Excel._Application.get_Selection()
AddinExpress.MSO.2005.dll: N 00000 (0x0) JIT
ExcelAddIn.AddinModule.AdxCommandBarButton1_Click1(sender As Object)
AddinModule.vb: line 0094, col 09, IL 0007 (0x7)
AddinExpress.MSO.ADXCommandBarButton.OnButtonClick(button As ICommandBarButton, handled As Boolean&)
AddinExpress.MSO.2005.dll: N 0053 (0x35) IL
(Outer Exception)
Date and Time: 21/01/2007 13:46:54
Machine Name: TOMER-ST
IP Address: 10.0.0.25
Current User: TOMER-ST\Tomer
Application Domain: c:\Documents and Settings\Tomer\Desktop\ExcelAddInTest\ExcelAddIn\bin\Debug\
Assembly Codebase: file:///C:/WINDOWS/assembly/GAC_32/AddinExpress.MSO.2005/2.4.1757.1__c20c070a1fc9a144/AddinExpress.MSO.2005.dll
Assembly Full Name: AddinExpress.MSO.2005, Version=2.4.1757.1, Culture=neutral, PublicKeyToken=c20c070a1fc9a144
Assembly Version: 2.4.1757.1
Assembly Build Date: 23/10/2004 00:00:02
Exception Source:
Exception Type: AddinExpress.MSO.ADXExternalException
Exception Message: Error occured in the code of the add-in.
Exception Target Site: Object reference not set to an instance of an object.
---- Stack Trace ----
|
|
Sergey Grischenko
Add-in Express team
Posts: 7235
Joined: 2004-07-05
|
Hi Tomer.
It seems that the system registry stores the incorrect information about the Excel type library. What version of Office do you use? Have you ever reinstalled MS Office several times on your PC?
P.S. Note that we take up your forum requests in the order we receive them.
Besides, it may take us some time to investigate your issue. Please be sure we will let you know as soon as the best possible solution is found.
|
|
tomer st
Guest
|
hi,
i'm using office 2003 (version 11.5612.6568)
i did install the office several times... |
|
Sergey Grischenko
Add-in Express team
Posts: 7235
Joined: 2004-07-05
|
|