XLS Object

AddWorkBook

 
Syntax
 
strName = XLS.AddWorkBook()
 
Description
Adds a new workbook to the active Excel session an returns the nam of the newly created workbook.
 
If Excel was not properly started, this function wil automatically initialise an Excel session by executing the AppInit function.
 
See Also
OpenWorkBook, WorkBookCount
Example
 
Sub Main
 
Dim strName As String
 
   XLS.AppInit
 
   strName = XLS.AddWorkBook()
 
   Debug.Print XLS.ActiveWorkBook      'Map1
 
   XLS.CloseWorkBook
 
   XLS.AppClose
 
End Sub