Most of my clients, who will be using the macros, are using Excel 97

Enough said. You're doomed unless you develop or at least test in Excel 97.
There have been lots of changes to the Excel and Office object models since
97 and some changes to VB proper.

--
Jim
"CoachMitch" wrote in message
...
|I am having macros made up. The coders are using Excel 2003. I am using
Excel
| 2007. Most of my clients, who will be using the macros, are using Excel
97.
|
| The sample macros (2003) that the coders are sending me are showing AddIn
| Exceptions when I open them in 2007. They are opening and working, but I
| worry that my clients using older versions will not be able to run the
macros.
|
| Is the Text to Column feature in the 97 and 2003 Excel versions.
|
| An example of an error statement:
|
| AddInExpress.MSO.ADXExcelAppE vents error
|
| Detailed technical information follows:
| ---
| (Inner Exception)
|
| 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)
|
| 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 ----
|
|
| Thanks for any help,
| Mitchell
|