bpolaski

.onTime in process book VBA

Discussion created by bpolaski on Mar 24, 2014
Latest reply on Mar 25, 2014 by Sam Pride

I have a trend that contains an embedded excel sheet which only updates when the trend is opened. The excel sheet just has some current value information gathered with Data Link.

 

My goal is to have it update every 5 seconds and display this on the trend, I wanted to use:

 

 

 

Application.onTime

 

 

 

which works in excel but not in process book? (The method is not supported) Is there another way to do this?

Outcomes