+ Reply to Thread
Results 1 to 2 of 2

VBA forcing to a DDE server to refresh

Hybrid View

  1. #1
    Registered User
    Join Date
    07-28-2010
    Location
    stgo
    MS-Off Ver
    Excel 2003
    Posts
    3

    VBA forcing to a DDE server to refresh

    Hi there.
    I have a spreadsheet receiving data (stock quotes) from a DDE server.
    However this DDE server send quotes into Excel just when prices changes.
    Sometimes, when the stock markets are calm or quiet the prices don't change for "long" period of time (I mean, for more than 2 minutes).

    Here is my problem:
    I need that DDE server send quotes information each short periods of time, for example each 5 seconds.

    It seems that I need to "force" to the DDE to send information into the spreadsheet even thought the prices don't change.

    I have tried to do this with a VBA macro using Ontime and the VBA UpdateLink methods:
    ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

    But however this sentence line doesnt "force" to the DDE send to send a quote.

    Any Idea if this is possible to do with a VBA macro.?
    I don't know if the VBA DDERequest method can "force" to the DDE server to do a refresh

    Best Regards
    Hernan

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: VBA forcing to a DDE server to refresh

    Hello Herman,

    It is difficult to give you a specific answer since you don't mention how the DDE is initiated. I would presume you have used a Web Query to retrieve the stock values and place them on a worksheet.The minimum refresh time for a query is 1 minute.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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