Excel 2007
 

Is the 1mb of code all in one module?
--
Jim Cone
Portland, Oregon USA



"Brettjg"

wrote in message
Hello out there. I'm currently using XP 2003 with Excel 2003 and I've got a
particular suite of pretty intricate spreadsheets that use about 1mb of VB
code.

I've heard that upgrading to Excel 2007/Vista is not so easy to do because
of incompatibility, and I don't want the grief of a complete
rewrite/modification. On the other hand I'm sick to bloody death of Excel
2003 crashing because it feels like it.

What are your thoughts please? I'm happy to hear many views on this.
Regards, Brett.

Excel 2007
 

Hi Jim, no the code is split up into 20 or more modules in PERSONAL.xls

"Jim Cone" wrote:


Is the 1mb of code all in one module?
--
Jim Cone
Portland, Oregon USA



"Brettjg"

wrote in message
Hello out there. I'm currently using XP 2003 with Excel 2003 and I've got a
particular suite of pretty intricate spreadsheets that use about 1mb of VB
code.

I've heard that upgrading to Excel 2007/Vista is not so easy to do because
of incompatibility, and I don't want the grief of a complete
rewrite/modification. On the other hand I'm sick to bloody death of Excel
2003 crashing because it feels like it.

What are your thoughts please? I'm happy to hear many views on this.
Regards, Brett.