decadt rik Posted September 3, 2018 Report Share Posted September 3, 2018 Ik krijg mijn waarden op de Excel-pagina maar kan maar 1 waarde zien. Ik zou mijn waarden elke minuut willen zien, zodat ik er een grafiek van kan maken. Ik gebruik nu M90 en ik lees het in Excel via uniDDe server. Wie geeft mij advies? 1 Quote Link to comment Share on other sites More sharing options...
MVP 2023 Joe Tauser Posted September 4, 2018 MVP 2023 Report Share Posted September 4, 2018 Translated: I get my values on the Excel page but can only see 1 value. I would like to see my values every minute so that I can make a graph out of them. I now use M90 and I read it in Excel via uniDDe server. Who gives me advice? First, post your .ude file you configured in UniDDE. If you want the value to auto-update you'll need a looping macro in Excel to read the data every minute. All the DDE server does is provide a data link that must be triggered from Excel to read. Joe T. Quote Link to comment Share on other sites More sharing options...
decadt rik Posted September 4, 2018 Author Report Share Posted September 4, 2018 Dear, I get my values on my excel sheet but I do not know how to make that loop and where you have to put that loop. Who can help me? thanks in advance Quote Link to comment Share on other sites More sharing options...
MVP 2023 Joe Tauser Posted September 5, 2018 MVP 2023 Report Share Posted September 5, 2018 Writing Excel macros is outside the scope of this forum, unless somebody want to chime in. Google "Excel time loop macro" - there seems to be quite a few posts in more Microsoft Office forums that should help. Joe T. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.