How Can I Run a STATISTICA Analysis from Microsoft Excel?
First, if you want to run STATISTICA from within the Visual Basic environment in Microsoft Excel, be aware of the issues (and some limitations). To illustrate, we will create an example program that can be run from Visual Basic within Excel. After starting Excel, create a new Worksheet. Then select Macro – Visual Basic Editor from the Tools menu. From the Visual Basic Tools menu, select References. The References dialog allows you to select the libraries (objects) that you would like to be visible inside the Visual Basic program. To make STATISTICA visible, select the STATISTICA Object Library, and the STATISTICA Basic Statistics Library (for the current version of STATISTICA); then click the OK button. Now type or paste the following program into the program editor.
