Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Vista and VB6 DLL

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default Vista and VB6 DLL

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Vista and VB6 DLL

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Vista and VB6 DLL

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   Report Post  
Posted to microsoft.public.excel.programming
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






  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Vista and VB6 DLL

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XP vs Vista vs 7 Ernesto Torvals New Users to Excel 2 January 25th 10 11:34 PM
VISTA PaulaC New Users to Excel 1 July 28th 09 02:13 PM
vista ramone Setting up and Configuration of Excel 2 September 28th 08 12:40 AM
Vista Doreen P Excel Discussion (Misc queries) 0 April 5th 07 01:56 AM
Vista Bill Martin[_2_] Excel Programming 1 April 5th 06 03:55 AM


All times are GMT +1. The time now is 12:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"