VBA References
 

Here is my current situation. I am updating a spreasheet
that has a lot of VBA code behind the scenes using
XL2002 - XP. At the same time I am updating it in XP I
am also verifying that the same spreadsheet works
properly in XL97. Currently I am having a problem with a
object reference in XL97. It does not recognize the
Replace function like it does in XL2002. I have the
correct DLL to link the reference, but the DLL I keep
trying to add says "Name conflicts with existing module,
project, or object library". I tried to remove the
existing reference but it continuous says "Can't remove
control or refernce; in use"

What can I do? I need to utilize the Replace function,
but at the same time I need it to be backwards
compatibile. Any ideas?

Any and all help would be appreciated.

Thanks.

Kirk

VBA References
 

There is no Replace function in VBA in Office 97.

Two ways around the problem:

1. If you have VB 6, you can create an Active DLL that uses the Replace
function in VB 6 and call the code from VBA when running in Excel 97, and
even Excel 2000 and 20002.
2. You can write your own Replace function.

--
http://www.standards.com/; Howard Kaikow's web site.
------------------------------------------------
"Kirk" wrote in message
...
Here is my current situation. I am updating a spreasheet
that has a lot of VBA code behind the scenes using
XL2002 - XP. At the same time I am updating it in XP I
am also verifying that the same spreadsheet works
properly in XL97. Currently I am having a problem with a
object reference in XL97. It does not recognize the
Replace function like it does in XL2002. I have the
correct DLL to link the reference, but the DLL I keep
trying to add says "Name conflicts with existing module,
project, or object library". I tried to remove the
existing reference but it continuous says "Can't remove
control or refernce; in use"

What can I do? I need to utilize the Replace function,
but at the same time I need it to be backwards
compatibile. Any ideas?

Any and all help would be appreciated.

Thanks.

Kirk

VBA References
 

In xl97, you can use application.substitute() to replace Replace.

(I liked typing that sentence!)

Kirk wrote:

Here is my current situation. I am updating a spreasheet
that has a lot of VBA code behind the scenes using
XL2002 - XP. At the same time I am updating it in XP I
am also verifying that the same spreadsheet works
properly in XL97. Currently I am having a problem with a
object reference in XL97. It does not recognize the
Replace function like it does in XL2002. I have the
correct DLL to link the reference, but the DLL I keep
trying to add says "Name conflicts with existing module,
project, or object library". I tried to remove the
existing reference but it continuous says "Can't remove
control or refernce; in use"

What can I do? I need to utilize the Replace function,
but at the same time I need it to be backwards
compatibile. Any ideas?

Any and all help would be appreciated.

Thanks.

Kirk

--

Dave Peterson