VBA References Problem

[Marcus]

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

 

[Tom Ogilvy]

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.