VBA networking

[questionit]

If i want to show a message with MsgBox on a different machine.

Please advise how i would write the code to send this message from my PC to someone else's PC.

I need help in just basic networking - send message.

Can anyone help.
It has to be with VBA


Thanks

[Rabbit]

I'm not an expert at networking but, here's the gist of what you need.

1) You need a program that will send a packet to the ip address and port of the chosen computer.

2) The computer needs a program running that will monitor the port for traffic and interpret it.

This is the direct approach.

I suppose with Access you could do something a little more convoluted.

1) Both machines have an Access program that is linked to a table on a network share.

2) The user you want to send a message to has a unique ID.

3) There is a table in the network shared database that stores messages and who it belongs to.

4) Your machine can insert messages into that table.

5) The user's Access program monitors this table for messages destined for it. If it finds one, it pops up a message box and then deletes the message and continues monitoring.