Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto force a macro
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto force a macro
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 "Jase" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto force a macro
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? "Joel" wrote: 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 "Jase" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto force a macro
Data - Import External data - New Web Query
"Jase" wrote: 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? "Joel" wrote: 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 "Jase" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Force read-only in auto_open macro | Excel Discussion (Misc queries) | |||
auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
How do I force an Excel macro to ask me which file and directory? | Excel Discussion (Misc queries) |