Are Excell 2007 macros backwaards compatible?

C

CoachMitch

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_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)

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
 
J

Jim Rech

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
|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_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)
|
| 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
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compatibility issues w Excel 97-03 to 2007 1
Error after sync 2
Any suggestions? Error message 0
Embedding Windows Form Control to ASP .NET Security Problem 2
Could not load file or assembly... 3
Could not load file or assembly 2
EntLIb 3.1 and Ajax Enabled App hosted in Medium trust Probs 4
Linking or Compiling Dependencies into a .Net Assembly 1

Top