Syntax
| XLS.AddWorkSheet SheetName
| ||||
|---|---|---|---|---|---|
Description
| Adds a new worksheet to the active workbook
If there is no active Excel session, this sub will automatically initialise a new Excel session, using the AppInit function.
The newly created worksheet will automatically be set as active.
| ||||
See Also
| |||||
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
|