Code for Range Monitoring / Trigger Shell Command

schelber

Board Regular
Joined
Oct 22, 2005
Messages
172
could someone point me in the right direction for how VBA would look if:

on worksheet Buffer Status:

I have temperature ranges in Rows 7-20, Column G and their minimum threshold in column H and their maximum threshold in column I:

such that if the value in G is > corresponding threshold in I and < than corresponding threshold in H then execute shell command

Shell "C:\Program Files\Skype\Phone\Skype.exe" /callto:+12156522325 AND

run macro 'SendEMail'.........so that a list of mailers will be notified

I already have the SendEMail code working OK and I want to paste this code right into the worksheet called Buffer Status.

Just not sure how it would look.

Thanks for any help on this.......I have not been able to find many examples of shell commands triggered by cell values.

Rich
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,057
Office Version
  1. 365
Platform
  1. Windows
Rich

Do you want to trigger code when cell values change?
 

schelber

Board Regular
Joined
Oct 22, 2005
Messages
172
exactly.........i have a spread that has those temp values updated every hour via server over a VPN and should any breach the assigned thershold I want to execute the

SendEMail macro and trigger a macro to execute a shell command below:

"C:\Program Files\Skype\Phone\Skype.exe" /callto:+12156522375

Thanks , Rich
 

Watch MrExcel Video

Forum statistics

Threads
1,118,452
Messages
5,572,209
Members
412,448
Latest member
ManuW
Top