Thanks so much for your ideas, Jason!
Visual Studio is not installed on my target machine,
so I don't think there is a "Visual Studio Command Prompt menu item"
However, the lone user on that machine has all administrator rights.
But if my DLL appears in the References Dialog,
isn't that pretty good evidence that Regasm has registered it properly?
The DLL is certainly compiled as 32-bit -
I don't do anything in the 64-bit world.
I would welcome more ideas/insights.
Post by MacDermott
I have an activex dll I wrote in vb.net, and want to call from VBA behind
I register it on the target machine using RegAsm.
This works fine under Windows XP,
but fails with "ActiveX cannot create object" under Windows 7.
My guess is that you're supposed to right-click the Visual Studio Command
Prompt menu item, select Run As Administrator, then try using regasm.
Or, you could probably create a batch file to do what you want, then run
it as administrator.
You should probably also take care to compile as 32-bit, ie don't use Any
CPU (especially if running on 64 bit O/S).