Live excel data Sheet should generate an SMS

[Techtrend]

Hello

Attached is is a live sheet data format,
The data gets updated in the live market,
The last k COL is the place where the BUY ,SELL gets generated automatically when the conditions meet.

As and when the BUY ,Sell is generated we need to Trigger an SMS.
We can integrate an 3rd Party sms plan for this.

Please let me know if any one help me on this.

Regards
Narendra

 

[Hui]

That can be done with a Worksheet_Change event trigger and a DOS Cmd

Do you have the command line for generating the SMS Code ?

 

[Techtrend]

NO i dont have any command line for SMS ,This needs to be done

 

[Hui]

Do you know what program your going to use to send the SMS ?

 

[Techtrend]

we can use any 3rd party SMS Application

 

[Hui]

Add the following code to the Worksheet Module for the

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

' Send a SMS if Column K Changes

If Intersect(Target, Range("K2:K100")) Is Nothing Then Exit Sub

If UCase(Target.Value) <> "BUY" Or UCase(Target.Value) <> "SEll" Then Exit Sub

'Put code for SMS Send here
'Target.Address is the cell that changed
'Target is the value of the cell that changed

End Sub

or see attached file

 

[Techtrend]

Hello Hui


thanks,Will check and revert back.

Narendra