GraFit 7: Automation

A major new feature of GraFit version 7 is the facility to use OLE Automation to pass data between GraFit and applications that support Automation, such as Microsoft Excel. Automation lets you control the data transfer programmatically, typically using Visual Basic for Applications (VBA). Using VBA within Microsoft Excel it is possible to pass data from Excel into GraFit, fit the data and pass the results back into Excel.

The sample Excel file "Inset Data Kinetics" that comes with GraFit version 7 has a GraFit graph embedded within an Excel spreadsheet. Data from the spreadsheet is automatically passed to GraFit, fitted, and the fitted parameter values returned to Excel. Automation allows this to be done and the graph updated in real time as the data are entered. (Click to enlarge)

See Automation in Action

See what is new in GraFit version 7

Excel-GraFit Automation using the GraFit Fitter template

Tutorial video: Excel-GraFit transfer made easy using the GraFit Fitter template

Tutorial video: Advanced Excel-GraFit Automation Programming