View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anthony[_4_] Anthony[_4_] is offline
external usenet poster
 
Posts: 9
Default 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