Send text to a port in VBA?

[Milos Setek]

Hi all,

I want to send a text string to some port using a socket connection from VBA
in excel. Is this possible?

Thanks for any help,
Milos

 

[Lars-Eric Gisslén]

Milos,

You can do it with WinInet API's. It takes some coding but it's doable. I do
it from Word. Calling ASP scripts, downloading files, bitmaps and so on.
It's plain HTTP/FTP programming so there's no problem. Going down to WinSock
would be a real overkill when you can most of what you mostly will need with
WinInet.

 

[Milos Setek]

Thanks for that, you would not have a simple VBA example or know where there
is one?

Regards and many thanks,
Milos.

 

[Chirag]

Look at my site: http://officeone.mvps.org/ - I have got VBA code snippets
that use WinInet.

- Chirag

Shortcut Manager - Assign keyboard shortcuts to menu items and macros
http://officeone.mvps.org/ppsctmgr/ppsctmgr.html