VBA References Problem
 

I have encountered a problem with referencing. Is it
possible to save references within a excel spreadsheet. So
when you send a spreadsheet to a number of people on
different excel version they I do not encounter
referencing problems.
For example they have Excel8.olb rather than Excel9.olb

Many thanks

Marcus

VBA References Problem
 

The problem is that the references are being saved. You should develop
your workbook in the oldest version and distribute that. Then there would
not be a conflict. Newer versions are smart enough to know about older
versions, but obviously not vice versa.

--
Regards,
Tom Ogilvy

"Marcus" /uk wrote in message
...
I have encountered a problem with referencing. Is it
possible to save references within a excel spreadsheet. So
when you send a spreadsheet to a number of people on
different excel version they I do not encounter
referencing problems.
For example they have Excel8.olb rather than Excel9.olb

Many thank

Marcus