Thread: VBA References
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kirk[_2_] Kirk[_2_] is offline
external usenet poster
 
Posts: 17
Default 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