Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Periodically Store/Save Excel DDE Values
I have an Excel DDE file that updates periodically with quotes, portfolio
values, etc. I want to periodically collect a snapshot of the DDE values and store the data for review. So for example let's say the day's high is dynamically updated into cell B1, I would like to have look at B1 at specified times, retrieve the value of B1 at that time and store it in say cell B2. I cant seem to find an Excel function or formula tat would achieve this. Any ideas or tips? Many Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Periodically Store/Save Excel DDE Values
You would need a VBA routine that copied the values and saved them in
another range. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "**" wrote in message ... I have an Excel DDE file that updates periodically with quotes, portfolio values, etc. I want to periodically collect a snapshot of the DDE values and store the data for review. So for example let's say the day's high is dynamically updated into cell B1, I would like to have look at B1 at specified times, retrieve the value of B1 at that time and store it in say cell B2. I can't seem to find an Excel function or formula tat would achieve this. Any ideas or tips? Many Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
store inventory sheet(ex:sports equipment store) | Excel Worksheet Functions | |||
Need to store changing values from one cell | Excel Discussion (Misc queries) | |||
Periodically listing files in a folder | Excel Discussion (Misc queries) | |||
Store values of a dynamically changing cell | Excel Worksheet Functions | |||
Periodically exporting Excel sheet to HTML | New Users to Excel |