Rather than connect via sockets, why not use some of the functionality
already provided by Excel.

Data | Get External Data | Run Web Query

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"fernando" wrote in message
...
Hello,

I need to connect to a web server, extract some data and
put it in a worksheet. It would be much easier to extract
this data directly from excel than having to develop an
external application to do it.

Is it possible to open a TCP Socket with VBA in excel? if
it is, where can I find some information about it?

Thanks

Fernando E