View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Vista and VB6 DLL

Also, in Vista you may need to turn off UAC (User Account Control). At least
that's the only way I can get RegSvr32 to work in Vista, though I'd be very
interested to know otherwise.

Search "UAC" in Vista help to get to lead you there.

I suppose, begrudgingly, it's best to turn it back on when done.

Regards,
Peter T

"Chip Pearson" wrote in message
...
You need to register the DLL with RegSv32. From the Run dialog on the
Windows Start menu, enter

RegSvr32 "C:\Path\FileName.dll"

When you compile an ActiveX DLL in VB6, it is automatically registered on
that local machine. But when you move it to another machine, you must
RegSvr32 the file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


wrote in message
...
On 28 Nov, 19:53, "Gary Keramidas" <GKeramidasATmsn.com wrote:
just a guess, do you have to register the dll?

--

Gary

wrote in message


...



Hi,

I have an add-in that uses a VB6 DLL. It works perfectly in XP but
when it's in Vista the DLL doesn't link. I put the DLL in the
system32 folder.

Has any else come across this problem know a solution?

Thank you in advance.

Best

Meldrum- Hide quoted text -

- Show quoted text -


Hi Gary,

Thank you for your reply.

I thought about that but I use a XLA (VBA wrapper) to call the DLL
which avoided the hassle of registering the DLL, which did the trick
in 2000 and XP. Is Vista different in that all DLLs need registering
or it is it to do with access rights - just not sure.

Best

Meldrum