Re: $$Excel-Macros$$ How to manipulate a constantly changing cell

2012-02-16 Thread dguillett1
age- From: PeterE Sent: Wednesday, February 15, 2012 5:24 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ How to manipulate a constantly changing cell Using DDE, I have a cell that is constantly updated in a worksheet. (It is a stock price) How do I access and manipulate the information?

$$Excel-Macros$$ How to manipulate a constantly changing cell

2012-02-16 Thread PeterE
Using DDE, I have a cell that is constantly updated in a worksheet. (It is a stock price) How do I access and manipulate the information? For instance, if I want to know the high price that this value achieved between 8:00AM and 8:30AM and place it in another cell in the workbook, how would i do