Rockwell Automation FactoryTalk Historian SE ProcessBook 3.2 User Guide - Manual (Page 300)

●
●
●
●
●
FactoryTalk Historian ProcessBook User Guide
282
 ProcessBook displays may be used to exhibit dynamic data within
other container applications. In this case, the ProcessBook or display is
considered an object.
OLE Automation in FactoryTalk Historian
ProcessBook
OLE Automation of FactoryTalk Historian ProcessBook means that an
application or program outside FactoryTalk Historian ProcessBook can
manipulate FactoryTalk Historian ProcessBook objects such as displays or
symbols. Currently, applications with OLE capability include Microsoft
Excel, Access, and Visual Basic (VB), among others. A specific set of
properties and methods are associated with each object type.
Data from FactoryTalk Historian ProcessBook can be retrieved or
manipulated according to scripts originating outside FactoryTalk Historian
ProcessBook. For example, with the proper scripts in place, you could:
 Obtain a FactoryTalk Historian ProcessBook object, such as a display,
from FactoryTalk Historian ProcessBook and print it in an Excel
spreadsheet. In fact, you can write the script to retrieve the display
only when certain tag values or other conditions are met.
 Write a Visual Basic program to start FactoryTalk Historian
ProcessBook, assess a particular display, and then alter it in some way.
 Click a button in ProcessBook to make an Excel spreadsheet show the
average and raw data of the current trend in ProcessBook. Then you
could change the time range of the ProcessBook, click the button
again, and see the Excel spreadsheet update with the new time range.
Although Automation scripts are not required to use a dialect of Visual
Basic, at the present time, that is the most common approach. Rockwell
Automation is using Visual Basic as the standard testing language for OLE
Automation.