update other prog. while running VB-Excel macro
Posted on 1998-08-17
In an Excel spread sheet I have a cell which pulls a value (changing number) from another program with the formula:
Now I want to copy the actual value into another cell every 5 minutes (everytime a new cell, because the value is changeing) so that I can see the result after some 3 hours. I wrote a macro in
Visual Basic, but with that macro I do have the same value in each cell, because the other programm is not delivering the new value. Or is Excel not looking for the new one?
Question: How can I copy a changing value from one cell into anther automatically?