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.