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
| |
Example
| Sub Main
XLS.AppInit
XLS.OpenWorkBook "o:\documenten\mijnwerkboek.xlsx"
Debug.Print XLS.ActiveSheet 'Blad1
XLS.CloseWorkBook
XLS.AppClose
End Sub
|