Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
running a macro on every refresh of the screen
Hi,
I have a spreadsheet which is linked to live feeds from say Reuters. I need to write a macro which auto-runs itself every time the spreadsheet refreshes, or there is change in any of its cells. Something to the effect "On every refresh, Do bla bla bla". Is there a way to implement this in VB? TIA *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
running a macro on every refresh of the screen
Hi shovit,
Yes - you can use the Worksheet_Change event subroutine to do this. To get there, just right-click the worksheet's tab in Excel and select View Code. Then, change the left dropdown above the code module to Worksheet, then change the right dropdown to Change. Call your macro from that subroutine, and each time any cell on the Worksheet changes, your macro will be executed. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] shovit sahai wrote: Hi, I have a spreadsheet which is linked to live feeds from say Reuters. I need to write a macro which auto-runs itself every time the spreadsheet refreshes, or there is change in any of its cells. Something to the effect "On every refresh, Do bla bla bla". Is there a way to implement this in VB? TIA *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
running a macro on every refresh of the screen
Does this work when a cell is paste linked to another
excel file and that file changes, does that trigger the on change event? Wayne -----Original Message----- Hi shovit, Yes - you can use the Worksheet_Change event subroutine to do this. To get there, just right-click the worksheet's tab in Excel and select View Code. Then, change the left dropdown above the code module to Worksheet, then change the right dropdown to Change. Call your macro from that subroutine, and each time any cell on the Worksheet changes, your macro will be executed. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] shovit sahai wrote: Hi, I have a spreadsheet which is linked to live feeds from say Reuters. I need to write a macro which auto-runs itself every time the spreadsheet refreshes, or there is change in any of its cells. Something to the effect "On every refresh, Do bla bla bla". Is there a way to implement this in VB? TIA *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
running a macro on every refresh of the screen
Hi Wayne,
Are you referring to DDE, web queries, or something else? -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Wayne wrote: Does this work when a cell is paste linked to another excel file and that file changes, does that trigger the on change event? Wayne -----Original Message----- Hi shovit, Yes - you can use the Worksheet_Change event subroutine to do this. To get there, just right-click the worksheet's tab in Excel and select View Code. Then, change the left dropdown above the code module to Worksheet, then change the right dropdown to Change. Call your macro from that subroutine, and each time any cell on the Worksheet changes, your macro will be executed. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] shovit sahai wrote: Hi, I have a spreadsheet which is linked to live feeds from say Reuters. I need to write a macro which auto-runs itself every time the spreadsheet refreshes, or there is change in any of its cells. Something to the effect "On every refresh, Do bla bla bla". Is there a way to implement this in VB? TIA *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
running a macro on every refresh of the screen
I did a paste all - link from several other excel
spreadsheets. I notice when I update them the master spreadsheet is updated with new values. I tried to trigger the macro and the funny thing was it would trigger when i updated one of the subsidiary spreadsheets but not on the others, although the updates did happen. Wayne -----Original Message----- Hi Wayne, Are you referring to DDE, web queries, or something else? -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Wayne wrote: Does this work when a cell is paste linked to another excel file and that file changes, does that trigger the on change event? Wayne -----Original Message----- Hi shovit, Yes - you can use the Worksheet_Change event subroutine to do this. To get there, just right-click the worksheet's tab in Excel and select View Code. Then, change the left dropdown above the code module to Worksheet, then change the right dropdown to Change. Call your macro from that subroutine, and each time any cell on the Worksheet changes, your macro will be executed. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] shovit sahai wrote: Hi, I have a spreadsheet which is linked to live feeds from say Reuters. I need to write a macro which auto-runs itself every time the spreadsheet refreshes, or there is change in any of its cells. Something to the effect "On every refresh, Do bla bla bla". Is there a way to implement this in VB? TIA *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
running a macro on every refresh of the screen
Hi Wayne,
I think you're correct in that external links do not cause the Worksheet_Change event to fire. But the Worksheet_Calculate event does fire, so you may be able to use that. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Wayne wrote: I did a paste all - link from several other excel spreadsheets. I notice when I update them the master spreadsheet is updated with new values. I tried to trigger the macro and the funny thing was it would trigger when i updated one of the subsidiary spreadsheets but not on the others, although the updates did happen. Wayne -----Original Message----- Hi Wayne, Are you referring to DDE, web queries, or something else? -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Wayne wrote: Does this work when a cell is paste linked to another excel file and that file changes, does that trigger the on change event? Wayne -----Original Message----- Hi shovit, Yes - you can use the Worksheet_Change event subroutine to do this. To get there, just right-click the worksheet's tab in Excel and select View Code. Then, change the left dropdown above the code module to Worksheet, then change the right dropdown to Change. Call your macro from that subroutine, and each time any cell on the Worksheet changes, your macro will be executed. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] shovit sahai wrote: Hi, I have a spreadsheet which is linked to live feeds from say Reuters. I need to write a macro which auto-runs itself every time the spreadsheet refreshes, or there is change in any of its cells. Something to the effect "On every refresh, Do bla bla bla". Is there a way to implement this in VB? TIA *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide screen movements when a macro is running | Excel Discussion (Misc queries) | |||
EXCEL 2007 CHART REFRESH WHILE MACRO IS RUNNING | Charts and Charting in Excel | |||
Running a macro from an auto-refresh | Excel Worksheet Functions | |||
Auto refresh and DDE update is not work when running macro | Excel Programming | |||
How to stop screen blinking when running macro | Excel Programming |