Excel upgrading = code problems
 

Hi Robert
normally this should be no problem. You may post the relevant part of
your code which crashes

--
Regards
Frank Kabel
Frankfurt, Germany


Robert Pollock wrote:
Hi,

I have wriiten a collection of worksheets all interlinked with macros
in Excel 97. There now has been 3 computers with Excel 2003
introduced into the network, on these terminals the code crashes with
'Cannot find object library'. Also where the user has saved a file
using a control button with a 'save' macro attached to it, it has of
course saved it as the Excel 2003 version. This now crashes when
opened in Excel 97 itself. I really hope that I do not have to
rewrite 400 pages of code in Excel 2003, and even then the Excel 97
terminals will probably crash when accessing these macros.

Any suggestions, is there an easy way to get 2003 to work with 97
code, or am I in between a rock and a hard place ?

Robert Pollock