Auto force a macro

J

Jase

I have a worksheet linked to a live feed. When the live feed changes by $3 I
want it to automatically force a macro to be set off. Any idea how I could do
this?

Thanks,

Jase
 
J

Joel

Are you using a Query? There is an QueryTable_AfterRefresh(Success As
Boolean) function that can be triggered when the query is made. You will
somehow need to have both th new and old values. The AfterRefresh can do two
things

1) Compare the new Data against the Data Previous Value.
2) Move the New value(s) to a new column containing Previous Value
 
J

Jase

Ive never used a query before but it sounds like thats what I want to do. I
will need to have my price copied over if as a new start reference point if
my value reaches over $3.

How do I set up a query?
 
J

Joel

Data - Import External data - New Web Query

Jase said:
Ive never used a query before but it sounds like thats what I want to do. I
will need to have my price copied over if as a new start reference point if
my value reaches over $3.

How do I set up a query?
Click to expand...
 
Top