| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Macro (VBA) every 5 minutes
I have a spreadsheet that has a DDE link that updates data in a spreadsheet.
Row 1 has stock symbols Row 2 has price data (that updates every minute) (this is not the real data - i am just simplifying) Every 5 minutes, in a separate sheet, I would like, to have this data to be updated in a list of descending order. I can make a macro to do this, but I would like to automate this macro (or code or whatever) to run every 5 minutes. Is that possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run Macro (VBA) every 5 minutes
See http://www.cpearson.com/excel/ontime.htm
-- __________________________________ HTH Bob "d" wrote in message ... I have a spreadsheet that has a DDE link that updates data in a spreadsheet. Row 1 has stock symbols Row 2 has price data (that updates every minute) (this is not the real data - i am just simplifying) Every 5 minutes, in a separate sheet, I would like, to have this data to be updated in a list of descending order. I can make a macro to do this, but I would like to automate this macro (or code or whatever) to run every 5 minutes. Is that possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert text entered as minutes/seconds to minutes | Excel Worksheet Functions | |||
| Convert Decimal Minutes to Hours-Minutes-Seconds | Excel Programming | |||
| Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
| add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
| Run Macro every 30 minutes | Excel Programming | |||
Linear Mode
