Excel Macro Alert
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 |
Excel Macro Alert
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 = " .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 " wrote: 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 |
Excel Macro Alert
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 On Nov 5, 7:33 pm, m wrote: 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 |
Excel Macro Alert
Thanks for the help guys. I will be trying out your ideas today.
Thanks Again, Adam Bush "Pete_UK" wrote: 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 On Nov 5, 7:33 pm, m wrote: 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 |
Excel Macro Alert
Okay, thanks for feeding back Adam.
Pete On Nov 6, 2:13 pm, m wrote: Thanks for the help guys. I will be trying out your ideas today. Thanks Again, Adam Bush "Pete_UK" wrote: 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 On Nov 5, 7:33 pm, m wrote: 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- Hide quoted text - - Show quoted text - |
All times are GMT +1. The time now is 02:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com