How to read Mac Sockets from Excel ?

[Jim]

Hi all -

How can sockets be used within Excel under MacOS X? In
Windows I'm using the "WinSock" ActiveX Control for this,
and I want to make my Excel VBA program portable to OS X,
but I can't find an equivalent to WinSock on the Mac.

Does anyone know how to read and write to sockets on the
Mac from an Excel VBA app?

Thanks!

-Jim

 

[Jim Gordon]

Hi Jim,

There's no Windows Active-X on Macs. What are you trying to accomplish?
There may be something else you can use.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

 

[Jim Marhaus]

There's no Windows Active-X on Macs.

What are you trying to accomplish?

I want to read and write to a TCP/IP socket from within an
Excel VBA program on the Mac. Specifically, I have a remote
spreadsheet engine that must communicate with Excel in real
time over TCP/IP. I'd like to do this with VBA, but since
ActiveX controls aren't available under OS X, I'm not sure
what to use.

If necessary I can write some middleware in C to handle the
TCP/IP requests and pass them on to my VBA program, but I'm
not sure how to call external programs from within VBA on
OS X. Perhaps this could be done with a combination of
applescript and VBA ?

Thanks!

-Jim Marhaus