John & Carole,

I developed Add-In which have been used across several versions of Excel,
primarily 97 and 2000. When the original xla was used in Excel 2000 it ran
like a dog (no offence to the canines reading this). The secret solution was
this: the xla needed to be freshly compiled in the version of Excel it was
intended to be used in.

In the VBE I exported all the forms and modules. I could then import these
separately into Excel 97 and 2000, compile and save them. Yes it meant there
were two separate versions but the effort was minimal for the returns. This
is particularly important if your project has any references set such as
ADO/DAO Word/Access object library.

Regards Marcus

"Carole O" wrote:

> John - I have the same problem - I design the forms in 2003, but the users
> have 2000. The VLOOKUP especially is a problem, and forget a VLOOKUP to a
> shared directory!!. I have convinced the budgetary powers that Excel 2000 is
> 5 years old, and everyone should be upgraded to 2003. I'm looking forward to
> checking out my theories when everyone is on-board with 2000. Hopefully you
> can use this argument (97 is 8 years old!!) to update your users. I don't
> have any hints about the VB error - sorry.
>
> Carole O
>
> "john.9.williams@bt.com" wrote:
>
> > Hi
> >
> > I have posted a few messages regarding userforms, i have a spreadsheet
> > built on excel2000, it uses multiple userforms. The program is used by
> > various people, some have no problems with it although some the program
> > crashes at various points. when they send it back to me it works fine.
> > I know some of them are using excel 97 could this cause the problem.
> > Also when i close the program if i do not save it it comes up with a
> > error saying visual basic out of memeory. Is there anyone out there
> > who can help me with this. I am not an advanced programmer so i find
> > it difficult to sought out a problem when it does not happen on my
> > machine. I am willing to send anyone the program to have a look at and
> > give me some pointers as to what i may have done wrong. please please
> > help.
> >
> > regards
> > john
> >
> >