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!

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
_______


"**" <**@discussions.microsoft.com> wrote in message
news:6BD6C23B-F5BA-4F9B-8F12-(E-Mail Removed)...
>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!
>