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_SheetActivat e(sender As Object,
hostObj As Object)
AddinExpress.MSO.2005.DLL: N 0013 (0xD) IL
AddinExpress.MSO.ADXExcelAppEvents.DoWorkbookActiv ate(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_SheetActivat e(sender As Object,
hostObj As Object)
AddinExpress.MSO.2005.DLL: N 0013 (0xD) IL
AddinExpress.MSO.ADXExcelAppEvents.DoWorkbookActiv ate(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_SheetActivat e(sender As Object,
hostObj As Object)
AddinExpress.MSO.2005.DLL: N 0013 (0xD) IL
AddinExpress.MSO.ADXExcelAppEvents.DoWorkbookActiv ate(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 ----