How can I access results spreadsheets, graphs, workbooks, etc.?
The STATISTICA Visual Basic object model (see What is meant by the term "object model?") provides access to practically all aspects of STATISTICA analyses, and the results of those analyses. When you perform an interactive analysis, and record a macro program (see also, How can I record my analysis in an SVB program?), you will see that all of your output choices are recorded. The most important thing to remember is that all output spreadsheets and graphs are returned as a Collection of spreadsheet and graph objects respectively (see also, What are collections?). You can retrieve and modify these objects in your program; for example, you can make the results (spreadsheet) of one analysis the input to the next analysis. Here is an example program:
Sub Main
Dim newanalysis As Analysis Dim s As Object Dim PPlot As Object ' Create the STATISTICA Basic Statistics Analysis object; ' open the input data spreadsheet (example file) 10items.sta ' NOTE: This file may reside in a different directory on ' your installation. Set newanalysis = Analysis (scBasicStatistics, _ Path & "\Examples\Datasets\10items.sta") ' Select from the startup dialog of Basic Statistics, option ' Descriptives (the first option on the startup dialog). newanalysis.Dialog.Statistics = scBasDescriptives ' "Click OK", i.e., Run this dialog. newanalysis.Run ' On the following dialog, select all variables 1-10. newanalysis.Dialog.Variables = "1-10" ' Make the Summary results (descriptive statistics) spreadsheet. Set s = newanalysis.Dialog.Summary ' Create a 2D Probability Plots object; use the results ' spreadsheet from the previous analysis as the input spreadsheet. Set newanalysis = Analysis (sc2dProbabilityPlots, s.Item(1)) ' Request a Normal Probability plot for variable 2 (Means). With newanalysis.Dialog
.Variables = 2 .GraphType = scProbNormal
End With ' Create the normal probability plot of means for all variables in ' file 10items.sta. Set PPlot = newanalysis.Dialog.Graphs PPlot.Visible = True
End Sub
However, in recorded macro programs, you will also see the so-called RouteOutput method, which will send the respective collection of output objects (graphs, spreadsheets) to stand-alone windows, workbooks, and/or report, depending on your current Analysis/Graph Output Manager settings.