XLS Object

ActiveWorkBook

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