CloseWorkBook

Syntax

XLS.CloseWorkBook [wbName,][SaveChanges,][fileName]

Description

This method closes a workbook and optionally saves the changed contents in the specified file.

Parameter	Description
wbName	String, optional. The name of the workbook that needs to be closed. If omitted or when a zero-length string is specified, the active workbook is closed.
SaveChanges	Boolean, optional. If omitted or True, the changes in the workbook will be saved. Setting this parameter to False will ignore any changes.

See Also

Example

Sub Main
 
Dim strName As String
 
   If Not XLS.AppInit() Then Exit Sub
 
   XLS.AppVisible = True
 
   strName = XLS.AddWorkBook()
 
   XLS.Value(1,1) = "Hello, world!"
 
   XLS.CloseWorkBook "", True, "o:\AdminSQL\Scripts\MijnWerkboek.xlsx"
 
   XLS.AppClose
 
End Sub