Excel Macro Alert

A

adambush4242

On a network of computers, is there any way to alert any of the other
computers when one computer runs a macro? I want to push a button on one
computer and run a macro. When this is done, I want a user on a separate
computer to know it's finished. THe best case would be if something could
appear on the other users screen, but I'm open to other ideas. I was also
thinking if the computer running the macro could make a sound of some sort to
alert the other users that it is finished.

Thanks and any input would be appreciated,

Adam Bush
 
L

Lance

It can't be done in the method you mentioned. What you can do is have excel
send an e-mail when the macro is run.

Sub SEND_MACRO_MAIL()
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String

Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)

strbody = "THE MACRO HAS BEEN RUN!!"

On Error Resume Next
With OutMail
.To = "[email protected]"
.CC = ""
.BCC = ""
.Subject = "THE MACRO HAS BEEN RUN!!"
.Body = strbody
.Send 'or use .Display
End With
On Error GoTo 0

Set OutMail = Nothing
Set OutApp = Nothing
End Sub
 
P

Pete_UK

You can add:

Beep

or

Beep: Beep: Beep

at the end of your code (just before the final End Sub) to indicate
that it has finished, or you could play a short .wav file - this link
shows how:

http://www.cpearson.com/excel/excelM.htm#PlayWAV

Are your computers close enough to hear sounds on another one?

Hope this helps.

Pete
 
A

adambush4242

Thanks for the help guys. I will be trying out your ideas today.

Thanks Again,

Adam Bush
 
P

Pete_UK

Okay, thanks for feeding back Adam.

Pete

Thanks for the help guys. I will be trying out your ideas today.

Thanks Again,

Adam Bush







- Show quoted text -
Click to expand...
 
Top