Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I suppose, begrudgingly, it's best to turn it back on when done.
The first thing I did after installing Vista was to turn off the UAC. It is a kludge solution to security, and it displays itself so often, users reactively click "Continue" without even reading what action is being approved. The boy who cried wolf and all that. The UAC is one of the dumber things to come out of Microsoft in quite some time. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Peter T" <peter_t@discussions wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XP vs Vista vs 7 | New Users to Excel | |||
VISTA | New Users to Excel | |||
vista | Setting up and Configuration of Excel | |||
Vista | Excel Discussion (Misc queries) | |||
Vista | Excel Programming |