Check out the below link
http://www.ostrosoft.com/oswinsck/oswinsck_vba.asp

If this post helps click Yes
---------------
Jacob Skaria


"faffo1980" wrote:

Hi all,
i am trying to use a socket controller inside a VBA application.
I'm using Windows Vista and Excel 2003.
I downloaded the winSock.ocx file and put it in c:\windows\system32
Then I registered the library through the regsvr32 command.

Unfortunately I keep on getting errors:
- If I try to istantiate the winsock object run time I get the error 429 in
the subject
- If I try to put the controller inside a form I receive another error; i
translate it from the italian message: "subject is not authorized executing
specified action"

Could anyone help me?

Thanks for your help

faffo1980