Backward compatibility of VB Excel programs

D

Didier Besset

I have developped an accounting application (freely available) on the MS
Windows Office 2000 version of Excel. This version has been installed on
various machines, including Windows XP and Excel running on Macintosh.
Recently one person attempted to move his workbooks from an old Mac (don't
know the precise version, unfortunately) to a Mac running Mac OS 8 (?) and
Excel 2004 (for sure). From what I gathered (I was not on site myself), the
VB program dies after a series of Copy/insert copied cells on an entire row.

Is there anywhere a list of changes between the various version of Excel?
Has anyone experienced a similar problem?

Thanks in advance for responding.

Cheers,

Didier
 
J

JE McGimpsey

Didier Besset said:
I have developped an accounting application (freely available) on the MS
Windows Office 2000 version of Excel. This version has been installed on
various machines, including Windows XP and Excel running on Macintosh.
Recently one person attempted to move his workbooks from an old Mac (don't
know the precise version, unfortunately) to a Mac running Mac OS 8 (?) and
Excel 2004 (for sure). From what I gathered (I was not on site myself), the
VB program dies after a series of Copy/insert copied cells on an entire row.

Is there anywhere a list of changes between the various version of Excel?
Has anyone experienced a similar problem?
Click to expand...

There haven't been any changes between MacXL98 and MacXL2004 (which runs
in MacOS X) - all the VBA versions are stuck at 5.00.

However, there was a bug in XL04 that made copying from VBA throw an
error. Your user should apply SP-1, preferably by running the Microsoft
AutoUpdate application, otherwise downloading it from the MacTopia
downloads site:

http://www.microsoft.com/mac/downloads.aspx
 
D

Didier Besset

After doing it with my user, I can confirm. This does the trick. Thanks
again.

Cheers,

Didier
 
Top