VBA Code Recompilation with new version of COM Dll

  • Thread starter Thread starter omahmood
  • Start date Start date
O

omahmood

Hi,

I have a spreadsheet that uses a COM dll in the VB code. For testign
purposes I have had to use a new version of the dll and lace it in a
different directory to the original and then regsvr32.

I find that the excel code seems "confused" as to the symbols of the
COM dll now referenced correctly to the new directory. In order to
unconfuse VB i must dereferene the project compile then re add the
reference and recompile. This sorts out my problems.

My issue is that I have multiple users using different versions of the
dll, how can I avoid or fix this annyoign issue?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference to DLL corrupts on recompile of dll 2
Process steps to compile current VBA macros into a DLL or COM Addin 1
Must VBA be manually converted to VB.NET (C++;C#) to create a DLL or Com Addin? 6
Recompile com object while excel is running 4
Need help in VBA for embedded object in excel 1
32 bit DLL with 64 bit Excel 2010 13
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Do I need DLL or COM Addin, Excel Addin 1

Back
Top