XLS Object

AppClose

 
Syntax
 
XLS.AppClose [SaveChanges]
 
Description
Closes the active Excel session and optionally saves changes in any opened workbook.
 
Parameter
Description
SaveChanges
Optional. If True, all changes in any workbook are saved before closing the Excel session.
 
Constant
Value
Description
True
-1
Save all changes
False
0
Do not save any changes
 
See Also
AppInit, AppVisible
Example
 
Sub Main
 
Dim strName As String
 
   XLS.AppInit
  
   strName = XLS.AddWorkBook()
 
   XLS.AddWorkSheet "MijnBlad"
 
   Debug.Print XLS.ActiveWorkBook                'Map1
   Debug.Print XLS.ActiveSheet                'MijnBlad
 
   XLS.CloseWorkBook
   XLS.AppClose
 
End Sub