View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1,560
Default Excel 2003/ Excel 97

I had a similar problem one time and i simply copied the code out and pasted
it in the newer version and it worked, although I am not sure why.
--
David


"Don Lloyd" wrote:

Hi all,

Happy Easter to everyone !

I have a small (<300k) workbook that makes fairly extensive use of VBA.
It has been developed in Excel 2003 and works fine (in Excel 2003).

I have tried running it on two other computers, both with Excel 97, and in
both cases it crashes - "This program has performed an illegal
operation...."

However, if I access the code and step through it (f8), it functions as
designed on both XL 97 computers.

For each module I've tried exporting the code, deleting the module and then
importing the code again but to no avail.

Any suggestions / pointers will be gratefully recieved

Don