PC Review
Home Forums Reviews Articles Register
Member Login:

PC Review > Forums > Newsgroups > Microsoft Excel > Microsoft Excel Programming > compatibility issues w Excel 97-03 to 2007

Reply
Thread Tools Rate Thread

compatibility issues w Excel 97-03 to 2007

 
 
CoachMitch
Guest
Posts: n/a
 
      25th Jun 2008
I am bidding out the creation of several macros. The sample worksheets are
all returning AddIn Exception errors.

After I click "Go" in the error dialog box, the macro will work.

The coders seem to think that they cannot make the macros completely
compatible across versions. This is an important aspect as my clients usually
run Excel 97-03 and I am running Excel 2007.

None of the coders know how to overcome this issue. I am wondering if the
differing versions is the real issue or if it is an easy villian?

The project has stopped until this issue is resolved.

Thanks for any input.
Coach Mitch


----------------------------------------------------------

All 3 instances had the same error message although the details were a bit
different:

AddOm Ex[ress/<SP/ADXExce;Appevemts error The AddIn has filed an exception.
Error occured in code of the setup MyAddIn1

Detailed technical information follows:
---
- 1st instance -

(Inner Exception)
Date and Time: 6/25/2008 3:54:08 AM
Machine Name: MITCHELL-571D94
IP Address: 192.168.1.3
Current User: MITCHELL-571D94\Mitchell Goldstein

Application Domain: C:\Documents and Settings\Mitchell
Goldstein\Application Data\azrajobs\setupMyAddin1Setup\
Assembly Codebase: file:///C:/Documents and Settings/Mitchell
Goldstein/Application
Data/azrajobs/setupMyAddin1Setup/AddinExpress.MSO.2005.DLL
Assembly Full Name: AddinExpress.MSO.2005, Version=4.0.1902.2005,
Culture=neutral, PublicKeyToken=4416dd98f0861965
Assembly Version: 4.0.1902.2005
Assembly Build Date: 3/17/2005 2:06:50 AM

Exception Source: Interop.Excel
Exception Type: System.Runtime.InteropServices.COMException
Exception Message: Invalid index. (Exception from HRESULT: 0x8002000B
(DISP_E_BADINDEX))
Exception Target Site: get__Default

---- Stack Trace ----

Excel.Sheets.get__Default(Index As Object)
AddinExpress.MSO.2005.DLL: N 00000 (0x0) JIT
setupMyAddin1.AddinModule.ExcelEvents_SheetActivate(sender As Object,
hostObj As Object)
AddinExpress.MSO.2005.DLL: N 0013 (0xD) IL
AddinExpress.MSO.ADXExcelAppEvents.DoWorkbookActivate(workbook As Object)
AddinExpress.MSO.2005.DLL: N 0008 (0x8) IL

(Outer Exception)
Date and Time: 6/25/2008 3:54:08 AM
Machine Name: MITCHELL-571D94
IP Address: 192.168.1.3
Current User: MITCHELL-571D94\Mitchell Goldstein

Application Domain: C:\Documents and Settings\Mitchell
Goldstein\Application Data\azrajobs\setupMyAddin1Setup\
Assembly Codebase: file:///C:/Documents and Settings/Mitchell
Goldstein/Application
Data/azrajobs/setupMyAddin1Setup/AddinExpress.MSO.2005.DLL
Assembly Full Name: AddinExpress.MSO.2005, Version=4.0.1902.2005,
Culture=neutral, PublicKeyToken=4416dd98f0861965
Assembly Version: 4.0.1902.2005
Assembly Build Date: 3/17/2005 2:06:50 AM

Exception Source:
Exception Type: AddinExpress.MSO.ADXExternalException
Exception Message: An error has occured in the code of the add-in.
Exception Target Site: Object reference not set to an instance of an object.

---- Stack Trace ----

- 2nd instance -

Detailed technical information follows:
---
(Inner Exception)
Date and Time: 6/25/2008 3:57:01 AM
Machine Name: MITCHELL-571D94
IP Address: 192.168.1.3
Current User: MITCHELL-571D94\Mitchell Goldstein

Application Domain: C:\Documents and Settings\Mitchell
Goldstein\Application Data\azrajobs\setupMyAddin1Setup\
Assembly Codebase: file:///C:/Documents and Settings/Mitchell
Goldstein/Application
Data/azrajobs/setupMyAddin1Setup/AddinExpress.MSO.2005.DLL
Assembly Full Name: AddinExpress.MSO.2005, Version=4.0.1902.2005,
Culture=neutral, PublicKeyToken=4416dd98f0861965
Assembly Version: 4.0.1902.2005
Assembly Build Date: 3/17/2005 2:06:50 AM

Exception Source: Interop.Excel
Exception Type: System.Runtime.InteropServices.COMException
Exception Message: Invalid index. (Exception from HRESULT: 0x8002000B
(DISP_E_BADINDEX))
Exception Target Site: get__Default

---- Stack Trace ----
Excel.Sheets.get__Default(Index As Object)
AddinExpress.MSO.2005.DLL: N 00000 (0x0) JIT
setupMyAddin1.AddinModule.ExcelEvents_SheetActivate(sender As Object,
hostObj As Object)
AddinExpress.MSO.2005.DLL: N 0013 (0xD) IL
AddinExpress.MSO.ADXExcelAppEvents.DoWorkbookActivate(workbook As Object)
AddinExpress.MSO.2005.DLL: N 0008 (0x8) IL

(Outer Exception)
Date and Time: 6/25/2008 3:57:01 AM
Machine Name: MITCHELL-571D94
IP Address: 192.168.1.3
Current User: MITCHELL-571D94\Mitchell Goldstein

Application Domain: C:\Documents and Settings\Mitchell
Goldstein\Application Data\azrajobs\setupMyAddin1Setup\
Assembly Codebase: file:///C:/Documents and Settings/Mitchell
Goldstein/Application
Data/azrajobs/setupMyAddin1Setup/AddinExpress.MSO.2005.DLL
Assembly Full Name: AddinExpress.MSO.2005, Version=4.0.1902.2005,
Culture=neutral, PublicKeyToken=4416dd98f0861965
Assembly Version: 4.0.1902.2005
Assembly Build Date: 3/17/2005 2:06:50 AM

Exception Source:
Exception Type: AddinExpress.MSO.ADXExternalException
Exception Message: An error has occured in the code of the add-in.
Exception Target Site: Object reference not set to an instance of an object.

---- Stack Trace ----

- 3rd instance -

:59:06 AM
Machine Name: MITCHELL-571D94
IP Address: 192.168.1.3
Current User: MITCHELL-571D94\Mitchell Goldstein

Application Domain: C:\Documents and Settings\Mitchell
Goldstein\Application Data\azrajobs\setupMyAddin1Setup\
Assembly Codebase: file:///C:/Documents and Settings/Mitchell
Goldstein/Application
Data/azrajobs/setupMyAddin1Setup/AddinExpress.MSO.2005.DLL
Assembly Full Name: AddinExpress.MSO.2005, Version=4.0.1902.2005,
Culture=neutral, PublicKeyToken=4416dd98f0861965
Assembly Version: 4.0.1902.2005
Assembly Build Date: 3/17/2005 2:06:50 AM

Exception Source: Interop.Excel
Exception Type: System.Runtime.InteropServices.COMException
Exception Message: Invalid index. (Exception from HRESULT: 0x8002000B
(DISP_E_BADINDEX))
Exception Target Site: get__Default

---- Stack Trace ----
Excel.Sheets.get__Default(Index As Object)
AddinExpress.MSO.2005.DLL: N 00000 (0x0) JIT
setupMyAddin1.AddinModule.ExcelEvents_SheetActivate(sender As Object,
hostObj As Object)
AddinExpress.MSO.2005.DLL: N 0013 (0xD) IL
AddinExpress.MSO.ADXExcelAppEvents.DoWorkbookActivate(workbook As Object)
AddinExpress.MSO.2005.DLL: N 0008 (0x8) IL

(Outer Exception)
Date and Time: 6/25/2008 3:59:06 AM
Machine Name: MITCHELL-571D94
IP Address: 192.168.1.3
Current User: MITCHELL-571D94\Mitchell Goldstein

Application Domain: C:\Documents and Settings\Mitchell
Goldstein\Application Data\azrajobs\setupMyAddin1Setup\
Assembly Codebase: file:///C:/Documents and Settings/Mitchell
Goldstein/Application
Data/azrajobs/setupMyAddin1Setup/AddinExpress.MSO.2005.DLL
Assembly Full Name: AddinExpress.MSO.2005, Version=4.0.1902.2005,
Culture=neutral, PublicKeyToken=4416dd98f0861965
Assembly Version: 4.0.1902.2005
Assembly Build Date: 3/17/2005 2:06:50 AM

Exception Source:
Exception Type: AddinExpress.MSO.ADXExternalException
Exception Message: An error has occured in the code of the add-in.
Exception Target Site: Object reference not set to an instance of an object.

---- Stack Trace ----
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      25th Jun 2008
Mitch -

All I learned from the messages you've attached is that we're not dealing
with VBA but instead it's VSTO. Generally knowing the line where the error
occurred and the precise error message are helpful. Your error dumps didn't
have this information. What I did get that was interesting was this:

> Exception Message: An error has occured in the code of the add-in.
> Exception Target Site: Object reference not set to an instance of an
> object.

The first line is oh so (un)helpful, but the second is providing information
(though not specific) about the problem. Your coders have to make sure all
objects are properly declared and instantiated. This may be at the root of
the versioning problem.

If there's a problem between versions, it can usually be worked out by
finding an order of commands that universally satisfies the versions, or
occasionally using if/then to provide different code paths for different
versions. Much of my work of late is updating Excel VBA projects to be
compatible with Excel 2007, so I know it can readily be done. In VSTO
though, there are different interops for the different versions of Excel, so
maybe the coders are correct in their assessment.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"CoachMitch" <(E-Mail Removed)> wrote in message
news:FC7104ED-A5F1-4BD7-B7FB-(E-Mail Removed)...
>I am bidding out the creation of several macros. The sample worksheets
>are
> all returning AddIn Exception errors.
>
> After I click "Go" in the error dialog box, the macro will work.
>
> The coders seem to think that they cannot make the macros completely
> compatible across versions. This is an important aspect as my clients
> usually
> run Excel 97-03 and I am running Excel 2007.
>
> None of the coders know how to overcome this issue. I am wondering if the
> differing versions is the real issue or if it is an easy villian?
>
> The project has stopped until this issue is resolved.
>
> Thanks for any input.
> Coach Mitch
>
>
> ----------------------------------------------------------
>
> All 3 instances had the same error message although the details were a bit
> different:
>
> AddOm Ex[ress/<SP/ADXExce;Appevemts error The AddIn has filed an
> exception.
> Error occured in code of the setup MyAddIn1
>
> Detailed technical information follows:
> ---
> - 1st instance -
>
> (Inner Exception)
> Date and Time: 6/25/2008 3:54:08 AM
> Machine Name: MITCHELL-571D94
> IP Address: 192.168.1.3
> Current User: MITCHELL-571D94\Mitchell Goldstein
>
> Application Domain: C:\Documents and Settings\Mitchell
> Goldstein\Application Data\azrajobs\setupMyAddin1Setup\
> Assembly Codebase: file:///C:/Documents and Settings/Mitchell
> Goldstein/Application
> Data/azrajobs/setupMyAddin1Setup/AddinExpress.MSO.2005.DLL
> Assembly Full Name: AddinExpress.MSO.2005, Version=4.0.1902.2005,
> Culture=neutral, PublicKeyToken=4416dd98f0861965
> Assembly Version: 4.0.1902.2005
> Assembly Build Date: 3/17/2005 2:06:50 AM
>
> Exception Source: Interop.Excel
> Exception Type: System.Runtime.InteropServices.COMException
> Exception Message: Invalid index. (Exception from HRESULT: 0x8002000B
> (DISP_E_BADINDEX))
> Exception Target Site: get__Default
>
> ---- Stack Trace ----
>
> Excel.Sheets.get__Default(Index As Object)
> AddinExpress.MSO.2005.DLL: N 00000 (0x0) JIT
> setupMyAddin1.AddinModule.ExcelEvents_SheetActivate(sender As Object,
> hostObj As Object)
> AddinExpress.MSO.2005.DLL: N 0013 (0xD) IL
> AddinExpress.MSO.ADXExcelAppEvents.DoWorkbookActivate(workbook As
> Object)
> AddinExpress.MSO.2005.DLL: N 0008 (0x8) IL
>
> (Outer Exception)
> Date and Time: 6/25/2008 3:54:08 AM
> Machine Name: MITCHELL-571D94
> IP Address: 192.168.1.3
> Current User: MITCHELL-571D94\Mitchell Goldstein
>
> Application Domain: C:\Documents and Settings\Mitchell
> Goldstein\Application Data\azrajobs\setupMyAddin1Setup\
> Assembly Codebase: file:///C:/Documents and Settings/Mitchell
> Goldstein/Application
> Data/azrajobs/setupMyAddin1Setup/AddinExpress.MSO.2005.DLL
> Assembly Full Name: AddinExpress.MSO.2005, Version=4.0.1902.2005,
> Culture=neutral, PublicKeyToken=4416dd98f0861965
> Assembly Version: 4.0.1902.2005
> Assembly Build Date: 3/17/2005 2:06:50 AM
>
> Exception Source:
> Exception Type: AddinExpress.MSO.ADXExternalException
> Exception Message: An error has occured in the code of the add-in.
> Exception Target Site: Object reference not set to an instance of an
> object.
>
> ---- Stack Trace ----
>
> - 2nd instance -
>
> Detailed technical information follows:
> ---
> (Inner Exception)
> Date and Time: 6/25/2008 3:57:01 AM
> Machine Name: MITCHELL-571D94
> IP Address: 192.168.1.3
> Current User: MITCHELL-571D94\Mitchell Goldstein
>
> Application Domain: C:\Documents and Settings\Mitchell
> Goldstein\Application Data\azrajobs\setupMyAddin1Setup\
> Assembly Codebase: file:///C:/Documents and Settings/Mitchell
> Goldstein/Application
> Data/azrajobs/setupMyAddin1Setup/AddinExpress.MSO.2005.DLL
> Assembly Full Name: AddinExpress.MSO.2005, Version=4.0.1902.2005,
> Culture=neutral, PublicKeyToken=4416dd98f0861965
> Assembly Version: 4.0.1902.2005
> Assembly Build Date: 3/17/2005 2:06:50 AM
>
> Exception Source: Interop.Excel
> Exception Type: System.Runtime.InteropServices.COMException
> Exception Message: Invalid index. (Exception from HRESULT: 0x8002000B
> (DISP_E_BADINDEX))
> Exception Target Site: get__Default
>
> ---- Stack Trace ----
> Excel.Sheets.get__Default(Index As Object)
> AddinExpress.MSO.2005.DLL: N 00000 (0x0) JIT
> setupMyAddin1.AddinModule.ExcelEvents_SheetActivate(sender As Object,
> hostObj As Object)
> AddinExpress.MSO.2005.DLL: N 0013 (0xD) IL
> AddinExpress.MSO.ADXExcelAppEvents.DoWorkbookActivate(workbook As
> Object)
> AddinExpress.MSO.2005.DLL: N 0008 (0x8) IL
>
> (Outer Exception)
> Date and Time: 6/25/2008 3:57:01 AM
> Machine Name: MITCHELL-571D94
> IP Address: 192.168.1.3
> Current User: MITCHELL-571D94\Mitchell Goldstein
>
> Application Domain: C:\Documents and Settings\Mitchell
> Goldstein\Application Data\azrajobs\setupMyAddin1Setup\
> Assembly Codebase: file:///C:/Documents and Settings/Mitchell
> Goldstein/Application
> Data/azrajobs/setupMyAddin1Setup/AddinExpress.MSO.2005.DLL
> Assembly Full Name: AddinExpress.MSO.2005, Version=4.0.1902.2005,
> Culture=neutral, PublicKeyToken=4416dd98f0861965
> Assembly Version: 4.0.1902.2005
> Assembly Build Date: 3/17/2005 2:06:50 AM
>
> Exception Source:
> Exception Type: AddinExpress.MSO.ADXExternalException
> Exception Message: An error has occured in the code of the add-in.
> Exception Target Site: Object reference not set to an instance of an
> object.
>
> ---- Stack Trace ----
>
> - 3rd instance -
>
> :59:06 AM
> Machine Name: MITCHELL-571D94
> IP Address: 192.168.1.3
> Current User: MITCHELL-571D94\Mitchell Goldstein
>
> Application Domain: C:\Documents and Settings\Mitchell
> Goldstein\Application Data\azrajobs\setupMyAddin1Setup\
> Assembly Codebase: file:///C:/Documents and Settings/Mitchell
> Goldstein/Application
> Data/azrajobs/setupMyAddin1Setup/AddinExpress.MSO.2005.DLL
> Assembly Full Name: AddinExpress.MSO.2005, Version=4.0.1902.2005,
> Culture=neutral, PublicKeyToken=4416dd98f0861965
> Assembly Version: 4.0.1902.2005
> Assembly Build Date: 3/17/2005 2:06:50 AM
>
> Exception Source: Interop.Excel
> Exception Type: System.Runtime.InteropServices.COMException
> Exception Message: Invalid index. (Exception from HRESULT: 0x8002000B
> (DISP_E_BADINDEX))
> Exception Target Site: get__Default
>
> ---- Stack Trace ----
> Excel.Sheets.get__Default(Index As Object)
> AddinExpress.MSO.2005.DLL: N 00000 (0x0) JIT
> setupMyAddin1.AddinModule.ExcelEvents_SheetActivate(sender As Object,
> hostObj As Object)
> AddinExpress.MSO.2005.DLL: N 0013 (0xD) IL
> AddinExpress.MSO.ADXExcelAppEvents.DoWorkbookActivate(workbook As
> Object)
> AddinExpress.MSO.2005.DLL: N 0008 (0x8) IL
>
> (Outer Exception)
> Date and Time: 6/25/2008 3:59:06 AM
> Machine Name: MITCHELL-571D94
> IP Address: 192.168.1.3
> Current User: MITCHELL-571D94\Mitchell Goldstein
>
> Application Domain: C:\Documents and Settings\Mitchell
> Goldstein\Application Data\azrajobs\setupMyAddin1Setup\
> Assembly Codebase: file:///C:/Documents and Settings/Mitchell
> Goldstein/Application
> Data/azrajobs/setupMyAddin1Setup/AddinExpress.MSO.2005.DLL
> Assembly Full Name: AddinExpress.MSO.2005, Version=4.0.1902.2005,
> Culture=neutral, PublicKeyToken=4416dd98f0861965
> Assembly Version: 4.0.1902.2005
> Assembly Build Date: 3/17/2005 2:06:50 AM
>
> Exception Source:
> Exception Type: AddinExpress.MSO.ADXExternalException
> Exception Message: An error has occured in the code of the add-in.
> Exception Target Site: Object reference not set to an instance of an
> object.
>
> ---- Stack Trace ----
>
 
Reply With Quote
Reply

« Copy cell based on unique value - alternate rows - into 1 row,.... | About Application.OnUndo again »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Anyone solved the Lotus Notes - Outlook 2007 compatibility issues? Jack Vinson Microsoft Outlook Discussion 1 7th Feb 2010 07:25 PM
2007 compatibility issues Chad Cameron Microsoft Excel Programming 0 7th Jan 2010 03:20 PM
Huge 2007/Xp compatibility issues Shaft Guy Microsoft Powerpoint 3 11th Jul 2009 02:45 AM
Unable to open excel 2007 file in excel 2002 despite having installed compatibility pack for office 2007 CW Microsoft Excel Discussion 3 3rd Dec 2008 02:57 PM
Compatibility issues with MS 2003 & 2007? Roxy Microsoft Excel Misc 1 6th May 2008 06:00 PM


Features
Forums Startup Database Reviews Articles FAQ / Guidelines About Us
 

Advertising
 

Newsgroups
Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware
 


All times are GMT +1. The time now is 03:01 PM.
Powered by vBulletin®. Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2010, Crawlability, Inc.
Contact Us - Archive - Privacy Statement - Top