Michael S

Michael S

  • NA
  • 2
  • 0

Strange problem: calling .Net Assembly from Word VBA

Jun 21 2006 11:18 PM
Hi, Here is a problem I faced: I have written a .NET class deployed as an asembly, I registered it by using the "RegAsm.exe myclass.dll". Then I called my assembly by using a word template .dot file's vba code CreateObject("myclass.class1"). It works perfectly well when I installed it on a fresh computer (with newly installed windows XP SP2, Office 2003 etc). However, when I try to install it on another computer that is have previous version of my application installed. After I execute the same code that CreateObject("myclass.class1"), VBA start giving me all kinds of error messages, such as "One of more dependies are not found.". Then it seems that after failure to execute the assembly, windows seem to try to re-install my application and try to re-register the assembly then reboot. I have suspect that the problem could be that I did not register the assembly "myclass" correctly, however after I carefully checked the registry, it's the same as the one on the machine that the same installation works. Uninstall my application and re-install it produce the same problem. Can someone please help? I'm pretty desparate because I have tried everything I could think of.