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?

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?