Macro Emailing Challenging Problem

[Sandip]

Hello,

I have a two part problem.

First let me explain the sheet. My sheet has three fields
of interest, a stock price, and an upper limit and a lower
limit. The stock price is automatically updated from
Bloomberg.

I am trying to create an E-mail notification system that
will notify if the price breaks either limit. So far I
have created a macro that can check if the price is within
the limits and if not it will e-mail me. It works fine.

My problem is having the macro check the price about every
few minutes or so and having the spreadsheet open
automatically and macro run automatically. If I am away
from my desk I do not want 30 e-mails telling me the same
thing.

I guess what I am looking for is a way to create
a "listener" that can tell if the price has changed and
run the test/email macro again.

Thank you in advance for whatever help you can give me.

-Sandip

 

[Cesar Zapata]

an idea is....

1) Set up a start price in Sheet2!a1 (dummy cell)

2) when you download the data, compare if the new value is different from
Sheet2!a1
if so then run e-mail it.

3) Paste the current stock Value to sheet2 a1

and so on.

if you dont want to have Excel open all the time you can create an .BAT file
that will open your excel file and shedule at time intervals



hope it helps.


CZ