Excel DDE Data Capture
I have an excel spreadsheet that has dde links in it that are constantly updating. I need a snapshot of the value once every minute stored in the same spreadsheet but in a different worksheet. When the value is taken, I need it stored with a time stamp in one column and and the value in another like this:
Date/Time Value
1/27/12 21:36 15.61
1/27/12 21:37 15.73
I need to be able to add another column next to an existing column so that more data can be collected from a d…
Original post by Freelancer.com - New Projects