We invite you to contribute and would appreciate your input. To submit your own programs for inclusion here, e-mail: info@statsoft.com. We ask that you please follow the guidelines below to ensure that other users will best take advantage of your efforts:

1. Provide a description of the task the program will perform.
2. Provide a list of requirements for running the program (such as the type of Scrollsheet which must be active before running the program or the necessary data file needed to run the program properly).
3. Note any adjustments that must be made to the code before running the program (such as data file path or variable names).
4. Include comments throughout the code that will assist others in understanding each section's purpose. The better the documentation, the easier it will be for someone to use your program. Also, please include the description in (1) at the beginning of your program.

Disclaimer: StatSoft offers the User-exchange Forum in order to promote the sharing of STATISTICA BASIC, STATISTICA Command Language, STATISTICA Development Environment, and Visual Basic interface programs between STATISTICA users. We will attempt to post accurate and functional programs, no guarantee regarding these programs is provided by StatSoft, Inc.

STATISTICA can be controlled from within other applications, such as Visual Basic, using the STATISTICA Command Language (SCL). Programs written in SCL can be executed from within Visual Basic using the SHELL command. This allows for the complete integration of STATISTICA into your custom application or other applications such as ms Excel, ms Access, or ms Word.

Additionally, STATISTICA BASIC can be called from within other applications, such as Visual Basic, using the STATISTICA Command Language (SCL). Calls to one or multiple STATISTICA BASIC programs can be written in SCL using the STBASIC command. These SCL programs can then be executed from within Visual Basic using the SHELL command. This enables you to include functions from the STATISTICA BASIC libraries, such as the advanced Matrix Procedure Language library, into your custom application or other applications such as ms Excel, ms Access, or ms Word.

See also the STATISTICA Development Environment for information about how to manage STATISTICA data files from within Visual Basic and the Library of STATISTICA BASIC Programs.

1. Calling STATISTICA from within Visual Basic
2. Calling STATISTICA BASIC from within Visual Basic
3. Using STATISTICA Development Environment from within Visual Basic
   • Example 1: Opening a user-specified STATISTICA data file in ms Excel
   • Example 2: Creating a STATISTICA data file filled with random numbers
   • Example 3: Accessing Scrollsheets (saved as data files) from within Visual Basic

2300 East 14th Street, Tulsa, OK 74104
Phone: (918) 749-1119; Fax: (918) 749-2217
e-mail: info@statsoft.com

©Copyright StatSoft, Inc., 1984-2005.
StatSoft, StatSoft logo, STATISTICA, SEWSS, SEDAS, Data Miner, SEPATH and GTrees are trademarks of StatSoft, Inc.

The source code given here is provided with no warranty expressed or implied. We appreciate the contribution of users who share their programs with others.

Last update: 5 January, 1998.