[VBA-win7]

[the_unforgiven2]

Hi all, I have a problem with VBA. I would be very grateful if someone could help me.

Let me explain it:

- I have written a simple Macro in Excel 2003 which is able to open Matlab and communicate with it by means of a socket. Here is the relevant part of the code:

Public WithEvents Sock As MSWinsockLib.Winsock
Private Sub CommandButton1_Click()
    Call createServSocket(9000)
    'lunch file
    Shell ("C:\xxx")
End Sub
 
Public Sub createServSocket(port As Integer)
    Set Sock = New MSWinsockLib.Winsock
    Sock.Protocol = sckTCPProtocol
    Sock.LocalPort = port
    Sock.Listen
End Sub

IT WORKS using Excel 2003, Matlab R2007b and WINDOWS XP

the same code with the same version of Excel and Matlab but with WINDOWS 7 doesn't work! It gives me a runtime error 429. ActiveX can't create the object on this line

Set Sock = New MSWinsockLib.Winsock

I tried to:

- add MSWINSCK.OCX and register it
- add dao360.dll and register it
- add reference to Microsoft Winsock Control 6.0
- add reference to DAO library

but I couldn't find out why it doesn't work!

Do you have any idea?

please, help me.....

[baja_yu]

Welcome to the Forum!

You posted in the wrong section. This is for VB Classic, which is different from VBA. I'll notify mods to move the thread for you to the right section.

[Hack]

Moved To Office Development

[the_unforgiven2]

Welcome to the Forum!

You posted in the wrong section. This is for VB Classic, which is different from VBA. I'll notify mods to move the thread for you to the right section.

ops, I'm sorry

thanks

[jdc2000]

Possibly useful link:

http://support.microsoft.com/kb/828550

[the_unforgiven2]

Possibly useful link:

http://support.microsoft.com/kb/828550

thanks, but it is not a problem of automation. The automation itself it's ok.
It's a problem regarding the creation of the object Sock from MSwinsckLib.winsock....

So far I can't understand

[westconn1]

you would need to register the ocx as administrator
most problems are to do with limited user accounts and incorrect installations