XLS Object

ActiveSheet

 
Syntax
 
XLS.ActiveSheet = strName
 
Description
Returns or sets the active worksheet of the current workbook. If Excel is not running or no workbook is active, the property returns an empty string.
 
 
See Also
Activeworkbook, WorkSheetCount
Example
 
Sub Main
 
   XLS.AppInit
 
   XLS.OpenWorkBook "o:\documenten\mijnwerkboek.xlsx"
 
   Debug.Print XLS.ActiveSheet   'Blad1
 
   XLS.CloseWorkBook
 
   XLS.AppClose
 
End Sub