StaSpreadsheet.Close
This function closes the spreadsheet.
| Syntax | Parameters | Return Value |
|---|---|---|
| - | This function has no parameters. | This function does not return a value. |
SVB Example
Opening a spreadsheet from Enterprise:
Sub Main
Dim oOM As ObjectManager
'Reconnect into Enterprise
Set oOM = New ObjectManager
oOM.Reconnect Application
'Open the dataset from Enterprise into an in-memory spreadsheet
Dim spr As New StaSpreadsheet
spr.OpenFromEnterprise(oOM, _
"/Blake's Materials/Cat Clinic Patient Info.sta") 'Insert path to your STA file here
'Connect the in-memory spreadsheeet to a regular spreadsheet and show it
Dim mySpr As Spreadsheet
Set mySpr = Application.SpreadsheetFromStaSpreadsheet(spr)
mySpr.Visible = True
spr.Close
oOM.Disconnect
End Sub
Copyright © 2020. Cloud Software Group, Inc. All Rights Reserved.
