View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default "Error in loading DLL", VB6 ActiveX DLL

Scott,
By "the code will execute in debug mode without errors", you mean in the VB6
IDE ?
And in Excel, you set a reference to the DLL ?
Instantiate the object ?

A bit more info the error/not working may help us.

NickHK

"Scott" wrote in message
...

If anyone can help me, I will be very appreciative.

I've written an ActiveX DLL that has mysteriously stopped working on my
development machine but works fine on another test machine. Each machine

has
the same version of Excel (i.e. 2003) and is running the same dll and xls
file. However, on the development machine, the code will execute in debug
mode without errors (reference made to vbp file vs dll). I have tried a

lot
of things to resolve the issue: OS LiveUpdate, Office Update, delete dll

from
registry, register / unregister dll via regsvr32, checked dll using
Dependency Walker, etc but nothing has helped. Ideas anyone? Thanks!