How? Excel send text Msg to peer/peer vbnet users without server

**teacher5th** · 01-26-2008, 04:46 PM

I'm a teacher that needs to send one way text message to pop up on my student's screen. THey don't have office installed but my vb net2005 program. My network is just a simple peer to peer. Can I do this by just using tcp/ip and not installing any other service? THanks

**Leith Ross** · 01-26-2008, 04:53 PM

Hello teacher5th,

This is an Excel forum. We can answer questions relating to Excel, VBA, and other office related programs. Your question is about VB.Net. Post your question with a VB.Net group.

Sincerely,
Leith Ross

**teacher5th** · 01-26-2008, 09:03 PM

Thanks for replying but I mentioned that I need for excel to "Send out" a text message in the title. Sorry that I didn't make myself clearer. I know that vb net 2005 can read one in so I was just giving the specs of my system. Can anyone help me with the VBA code needed to send a one-way text message to my students? thanks

**B_Taylor** · 01-26-2008, 09:17 PM

You can, but why you would want to send it through excel is a mystery.

Simply run this in the command prompt:

Please Login or Register  to view this content.

So if the PC's name was "Computer1", you'd do:

Please Login or Register  to view this content.

**teacher5th** · 01-27-2008, 09:12 PM

thanks for your help. I would like to do it in excel since through a loop I can send it out to one, selected students or all. I can also store template messages that I can change at the last minute. Is it possible that someone can make a vba routine that will access a range of cells that would have messages in them and a range of computer names (Comp01, Comp02, etc to 32) that would allow me to send certain messages to a select group of students? thanks

**Macdave_19** · 01-29-2008, 04:56 AM

Hi Buddy I have created a messaging system Known as MaGoo Messenger, it simpplifies everything by using a userform, you select the target user it finds there ID (in your case this would be target computer ID and send the typed message.

Please Login or Register  to view this content.

The TxtKid is a textbox value representing the ID
and the txtmess is the message in a textbox

ill attach a pic for you to see!!

**Paul** · 01-29-2008, 05:38 AM

One thing to note, in order to use 'Net send..' commands, the Messenger service needs to be running on all PC's (both sending and receiving PC's). From experience, it is quite common to have that service disabled by the IT staff for various reasons.

**teacher5th** · 01-30-2008, 04:37 AM

Thanks Mr. Magoo and paul for taking the time to help. I will try it. If anyone out there would like to help make this a nice module so it would be easy for me to use it - various text messages pulled from cells and a student selection macro that would allow me to send to selected students or all of them, I would appreciate it. thanks

**Macdave_19** · 02-14-2008, 06:06 AM

A fully Functioning MaGoo Messenger:

The userform has an add friend and delete friend button that writes to sheet one in your personal macro workbook.

if you have any problems let me know.

what i have done is put these forms into my personal macro workbook then simply added this code to a module:

Please Login or Register  to view this content.

Then created a Custom macro buton on the menubar and assigned it the above macro.

Hey Presto you're done!!

Any comments or suggestions on the little bab boy are welocome.

**Macdave_19** · 02-14-2008, 06:09 AM

A fully Functioning MaGoo Messenger:

The userform has an add friend and delete friend button that writes to sheet one in your personal macro workbook.

if you have any problems let me know.

what i have done is put these forms into my personal macro workbook then simply added this code to a module:

Please Login or Register  to view this content.

Then created a Custom macro buton on the menubar and assigned it the above macro.

Hey Presto you're done!!

Any comments or suggestions on the little bad boy are welocome.

**Macdave_19** · 02-14-2008, 06:09 AM

A fully Functioning MaGoo Messenger:

The userform has an add friend and delete friend button that writes to sheet one in your personal macro workbook.

if you have any problems let me know.

what i have done is put these forms into my personal macro workbook then simply added this code to a module:

Please Login or Register  to view this content.

Then created a Custom macro buton on the menubar and assigned it the above macro.

Hey Presto you're done!!

Any comments or suggestions on the little bad boy are welcome.