Mid$ Function
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 |
Mid$ Function
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 |
Mid$ Function
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/de...entid=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 * "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 |
Mid$ Function
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 . |
Mid$ Function
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 . |
All times are GMT +1. The time now is 03:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com