Mid$ Function

  • Thread starter Thread starter Kirk
  • Start date Start date
K

Kirk

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
 
go into tools=>References in the VBE and clean up the reference(s) shown as
missing and it should work fine.
 
Hi Kirk,

The Mid$ function is not the problem, the problem is (assuming that you
correctly identified the MISSING reference) your reference to the ADO MD
object library. If you remove the Mid$ function VBA will just bomb somewhere
else until you fix this reference problem.

Since ADO is not specific to Excel, you either need to find a machine
with the earliest version of this object library and do your final
Debug/Compile and save there, or you need to update the ADO versions on all
of your machines so that they have the most current version of this object
library. You can download various ADO version updates (referred to as MDAC)
from the following web site:

http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001860

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
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
 
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?)
 
Back
Top