Cannot Create ActiveX Component when trying to call .Net DLL from Excel VBA
 

Hi

I have an Excel spreadsheet that calls a .Net DLL through VBA to run
certain functions.

This is the code that creates the object:

Public objFunction As Object
If objFunction Is Nothing Then
Set objFunction = CreateObject("MyDLL.Function")

For some users (a small, but important percentage of users), when they
try to run these functions they receive the error "Cannot Create
ActiveX Component".

I have tried to replicate their setup (same Windows XP and Office 2003
version and Service Packs) on my PC, but i cant seem to replicate this
error and it works fine for me and most users.

Anyone have any suggestions on what it could be? Permission Issues?
Other Conflicts?

Thanks
Anthony