Plant data can easily be collected by CX-Supervisor, but extra data analysis often requires data to be exported or imported from a spreadsheet like Microsoft Excel. For large amouts of data you can set up Data Logging.  To access a few cells of data though you can use a Microsoft ActiveX control to read and write direct to cell values.

' Launch Excel
set app = createobject("Excel.Application")

' Load a workbook
set wb = app.Workbooks.Open(s_ProjectPath + "\excelsheet.xls")

'define the cell you wish to use
set rng = wb.Activesheet.Range(CellonExcel)

'apply the value to the cell
rng.value = ExcelSetPoint

'Save, close, quit and tidy up - to avoid Excel hanging around in background
app.ActiveWorkbook.Save
app.Workbooks.Close

set rng = nothing
set wb = nothing
app.Quit
set app = nothing