A sample session

Navigation:  Example 4: Remote control by OLE automation >

A sample session

Previous pageReturn to chapter overview

Here is how you can work with the Excel/SCOUT combination:

 

Start Excel and load the file angles.xls.

With Alt-F11 switch to the VisualBasic editor. Run the routine 'Create_server'

Change to the main window of SCOUT which appears on the screen. With File|Open load the last configuration of example 3 of this tutorial.

Change back to Excel and start the macro compute_data. This will fill the Excel table with angle-dependent reflectance spectra calculated by SCOUT.

 

The Excel file contains a page called 'Graph' which shows a 3D view of the computed data:

 

In Excel, it is quite easy to change the type of graph. You could also display the data in a 2D view: