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 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. 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 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now