Sending a messages

M

Marnus

H

How can I use VBA to send a message to another user? For instance using Command prompt

Thanks
Marnus
 
J

Jim Rech

For instance using Command prompt

How would you do it manually from the command prompt? If you have a way you
might be able to do it from VB using the Shell function.

--
Jim Rech
Excel MVP
| Hi
|
| How can I use VBA to send a message to another user? For instance using
Command prompt.
|
| Thanks
| Marnus
 
J

Jim Rech

I understand that you want to send a message. But VB doesn't have a
built-in way to do that. It may be able to use Outlook or something else to
send a message. So what tool do you have and want to use?

--
Jim Rech
Excel MVP
| Hi
|
| I need the message more automated. I want to use it when information has
change it must send a message to a certain user advising that information
has changed.
|
| Thnaks
| Marnus
|
| ----- Jim Rech wrote: -----
|
| >> For instance using Command prompt
|
| How would you do it manually from the command prompt? If you have a
way you
| might be able to do it from VB using the Shell function.
|
| --
| Jim Rech
| Excel MVP
| | | Hi
| |
| | How can I use VBA to send a message to another user? For instance
using
| Command prompt.
| |
| | Thanks
| | Marnus
|
|
|
 
M

Marnus

Hi Ji

I've got it right by using the under mentioned

Function Message(
Range("A4").Selec
Selection.QueryTable.Refresh BackgroundQuery:=Fals
Range("A3").Selec
Dim RetVa
RetVal = Shell("H:\Commands\ADR.bat", 1) ' Run ba
End Functio

The problem is when something has changed it must send a message. I've tried to use an IF function, but didn't get right

Thank
Marnu


----- Jim Rech wrote: ----

I understand that you want to send a message. But VB doesn't have a
built-in way to do that. It may be able to use Outlook or something else to
send a message. So what tool do you have and want to use

--
Jim Rec
Excel MV
| H

| I need the message more automated. I want to use it when information has
change it must send a message to a certain user advising that information
has changed

| Thnak
| Marnu

| ----- Jim Rech wrote: ----

| >> For instance using Command promp

| How would you do it manually from the command prompt? If you have a
way yo
| might be able to do it from VB using the Shell function

| --
| Jim Rec
| Excel MV
| | | H
|
| | How can I use VBA to send a message to another user? For instance
usin
| Command prompt
|
| | Thank
| | Marnu


|
 
Top