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