Instead of having a reference to the library (called early binding), you could
use late binding.

You define your variables as generic objects and then when xl2k runs, it'll use
it's version.

But if you're creating excel objects/applications, you might not need it at
all. Just use the instance of excel that's running.

If that makes no sense at all, you may want to post a snippet of code--not the
workbook.


Michelle wrote:

Hello,

I have developed a set of code in Excel 2002 to
manipulate some excel raw data into a report structured
spreadsheet. This excel uses the excel reference library
v. 10.0. However, when I tried to run the same macro in
Excel 2000 machines, it does not recognize some of the
function calls. This I believe is due to it referencing
a v. 9.0 reference library. Is there anyway to point it
to the 10.0 reference library without updgrading the 2000
machine or downgrading the code to be restructured for
2000 format? The code is extremely lenghty, so any help
on this is much appreciated!

Thanks in advance,

Michelle

--

Dave Peterson