How to Periodically Store/Save Excel DDE Values

Discussion in 'Microsoft Excel Misc' started by Guest, Aug 9, 2007.

  1. Guest

    Guest Guest

    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!
     
    Guest, Aug 9, 2007
    #1
    1. Advertisements

  2. Guest

    Jon Peltier Guest

    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:...
    >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!
    >
     
    Jon Peltier, Aug 10, 2007
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest
    Replies:
    1
    Views:
    203
    Norman Harker
    Feb 27, 2004
  2. haven104

    Periodically listing files in a folder

    haven104, Jan 10, 2006, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    127
    Jack Sons
    Jan 10, 2006
  3. Serena
    Replies:
    0
    Views:
    272
    Serena
    Apr 28, 2009
  4. mavio
    Replies:
    0
    Views:
    573
    mavio
    Oct 16, 2009
  5. Replies:
    3
    Views:
    227
    Gord Dibben
    Oct 20, 2009
Loading...

Share This Page