Workbook.Name
Use this property to get the name of the workbook
SVB Example
Timestamping each item in a workbook
Option Explicit
Option Base 1
Sub Main
Dim newanalysis As Analysis
Set newanalysis = Analysis (scBasicStatistics, Application.Open(Application.Path & "\Examples\Datasets\Cat Clinic.sta"))
With newanalysis.Dialog
.Statistics = scBasDescriptives
End With
newanalysis.Run
With newanalysis.Dialog
.Variables = "3 6 9"
.PairwiseDeletionOfMD = True
.DisplayLongVariableNames = False
.ExtendedPrecisionCalculations = False
.PlotMedianQuartileRange = False
.PlotMeanSEAndSD = False
.PlotMeanSD196TimesSD = True
.PlotMeanSE196TimesSE = False
.UserDefinedPercentiles = False
.ValidN = True
.Mean = True
.Median = False
.Mode = False
.GeometricMean = False
.HarmonicMean = False
.ConfLimitsForMeans = False
.Sum = False
.StandardDeviation = True
.Variance = False
.StandardErrorOfMean = False
.MinimumMaximum = True
.LowerUpperQuartiles = False
.Range = False
.QuartileRange = False
.Skewness = False
.Kurtosis = False
.StandardErrorOfSkewness = False
.StandardErrorOfKurtosis = False
.UseNumberOfIntervals = True
.NumberOfIntervals = 10
.NormalExpectedFrequencies = False
.KSAndLillieforsTestForNormality = True
.ShapiroWilkWTest = False
.ConfidenceIntervalForMeansPlot = 95
.CompressedStemAndLeaf = False
End With
newanalysis.RouteOutput(newanalysis.Dialog.Summary).Visible = True
newanalysis.RouteOutput(newanalysis.Dialog.Histograms).Visible = True
newanalysis.Dialog.ResultsVariables = "6 | 9"
newanalysis.RouteOutput(newanalysis.Dialog.Scatterplot2D).Visible = True
Dim CurrentItem As WorkbookItem
Set CurrentItem = ActiveWorkbook.Root
While (TypeName(CurrentItem) <> "Nothing")
Set CurrentItem = ActiveWorkbook.NextItem(CurrentItem)
If TypeName(CurrentItem) = "Nothing" Then Exit While
If CurrentItem.Type <> scWorkbookItemTypeFolder Then
CurrentItem.Name = CurrentItem.Name & " " & Now
End If
Wend
End Sub
Copyright © 2020. Cloud Software Group, Inc. All Rights Reserved.
