+ Reply to Thread
Results 1 to 1 of 1

Update Links, DDE

  1. #1
    Registered User
    Join Date
    11-25-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    45

    Update Links, DDE

    I have a tricky problem that I need helping getting around. I use DDE to import data into Excel. When the there is no data streaming from the 3rd party softeare, Excel shows zeros in the cells, and when they are filled, it shows the respective data. When the data from the third party app is deleted, instead of showing that change on the spreadsheet, returning zeroes in all the cells, it simply stops changing (the data pauses at the last point before the data was deleted). However, if I close the spreadsheet and reopen it, I am prompted with the update links message box:

    DDE_Sample2.jpg

    When I click 'Update', it updates all links, and returns zeroes to all cells. What I need to do is find out what that 'Update' button is doing and how to set that to automatic, or write it into VBA.

    Attaching the spreadsheets won't help because you need other software to retrieve the data, so I uploaded some pics to better illustrate.



    With data feeding into Excel, the cells are filled with data. Cells that aren't receiving data are filled with zeroes:

    DDE_Sample1.jpg


    When the data stops feeding into Excel, the cells stop receiving data but they don't reset to zeroes. However, when I close and reopen the spreadsheet, and click 'Update' when prompted, the cells are reset back to zeroes:

    DDE_Sample3.jpg


    Any help is greatly appreciated.
    Last edited by jj554; 03-28-2013 at 01:04 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1