VBA References Problem

  • Thread starter Thread starter Marcus
  • Start date Start date
M

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
 
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.
 
Back
Top