Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to send a system message?
I am using Office 2003 on Windows XP.
Could someone please post example VBA code or script to send a system message to user(s)? - Or point me to a web site that may help. This would be extremely helpful when Oulook is down. Thanks much in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to send a system message?
Not exactly sure what you mean by a system message ... so could be two
possibilities: email or a message box. Look into these: CDO.Message (send email) MsgBox (popup a dialog box to the user) BBB "quartz" wrote in message ... I am using Office 2003 on Windows XP. Could someone please post example VBA code or script to send a system message to user(s)? - Or point me to a web site that may help. This would be extremely helpful when Oulook is down. Thanks much in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to send a system message?
Thanks for the reply, but actually, it's neither email nor a message box.
There is a method to send a system popup message to users on a network if you know their computer name - without using an email system. It is great whenever your email system is down. That is what I'm after...any ideas? "booner" wrote: Not exactly sure what you mean by a system message ... so could be two possibilities: email or a message box. Look into these: CDO.Message (send email) MsgBox (popup a dialog box to the user) BBB "quartz" wrote in message ... I am using Office 2003 on Windows XP. Could someone please post example VBA code or script to send a system message to user(s)? - Or point me to a web site that may help. This would be extremely helpful when Oulook is down. Thanks much in advance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to send a system message?
Use Shell and
Net Send ComputerName Msg or Net Send * Msg -- Regards, Tom Ogilvy "quartz" wrote in message ... Thanks for the reply, but actually, it's neither email nor a message box. There is a method to send a system popup message to users on a network if you know their computer name - without using an email system. It is great whenever your email system is down. That is what I'm after...any ideas? "booner" wrote: Not exactly sure what you mean by a system message ... so could be two possibilities: email or a message box. Look into these: CDO.Message (send email) MsgBox (popup a dialog box to the user) BBB "quartz" wrote in message ... I am using Office 2003 on Windows XP. Could someone please post example VBA code or script to send a system message to user(s)? - Or point me to a web site that may help. This would be extremely helpful when Oulook is down. Thanks much in advance. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to send a system message?
Thanks again Tom.
Do I need to reference a Shell library then? The VBE isn't recognizing "Net Send"... "Tom Ogilvy" wrote: Use Shell and Net Send ComputerName Msg or Net Send * Msg -- Regards, Tom Ogilvy "quartz" wrote in message ... Thanks for the reply, but actually, it's neither email nor a message box. There is a method to send a system popup message to users on a network if you know their computer name - without using an email system. It is great whenever your email system is down. That is what I'm after...any ideas? "booner" wrote: Not exactly sure what you mean by a system message ... so could be two possibilities: email or a message box. Look into these: CDO.Message (send email) MsgBox (popup a dialog box to the user) BBB "quartz" wrote in message ... I am using Office 2003 on Windows XP. Could someone please post example VBA code or script to send a system message to user(s)? - Or point me to a web site that may help. This would be extremely helpful when Oulook is down. Thanks much in advance. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to send a system message?
VBA has its own Shell command. Look at VBA's help for more info.
quartz wrote: Thanks again Tom. Do I need to reference a Shell library then? The VBE isn't recognizing "Net Send"... "Tom Ogilvy" wrote: Use Shell and Net Send ComputerName Msg or Net Send * Msg -- Regards, Tom Ogilvy "quartz" wrote in message ... Thanks for the reply, but actually, it's neither email nor a message box. There is a method to send a system popup message to users on a network if you know their computer name - without using an email system. It is great whenever your email system is down. That is what I'm after...any ideas? "booner" wrote: Not exactly sure what you mean by a system message ... so could be two possibilities: email or a message box. Look into these: CDO.Message (send email) MsgBox (popup a dialog box to the user) BBB "quartz" wrote in message ... I am using Office 2003 on Windows XP. Could someone please post example VBA code or script to send a system message to user(s)? - Or point me to a web site that may help. This would be extremely helpful when Oulook is down. Thanks much in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Message: Not enough system resources to display completely. | Excel Discussion (Misc queries) | |||
Display a message in system tray | Excel Discussion (Misc queries) | |||
Why error message - not enough system resources to display comple. | Excel Discussion (Misc queries) | |||
send email message | Excel Programming | |||
How to stop getting system message | Excel Programming |