Do your compile in xl97 and get it working with the proper reference - then
you can distribute that and it should work in both versions.

(are you actually using that DLL?)

--
Regards,
Tom Ogilvy

"Kirk" wrote in message
...
I can do that, but I need this spreadsheet to be
backwards compatible without having to have every user
who is using XL97 clean up the references. Right, Mid
and Left all do not work unless I fix the missing
reference (which is just a older version of the DLL). I
need it to work in both machines without any manual
changes happening.

Kirk


-----Original Message-----
go into tools=References in the VBE and clean up the
reference(s) shown as
missing and it should work fine.

--
Regards,
Tom Ogilvy

"Kirk" wrote in message
...
I have a spreadsheet that is used in both XP and XL97.
My problem is that I use the MID$ function to capture
some information. It works fine and dandy in XP, but
it
will not work in XL97. The problem is that there is a
newer version of the DLL (msadomd) in XP than in XL97.

I need to be able to determine if the active cell that
is
being modified is either the I or the J column. Is
there
a way in which I can do this that will work in both
XL97
and XP?

Any help would be appreciated. Thanks.

Kirk


.