How to open a workbook and activate a specific sheet

[Tushar]

@water

Hlo folks,

I m trying to open a workbook in excel and then open a particular sheet. I don't find any way to resolve this problem. I also trying _ExcelSheetActivate() function but this will not work.

Here is my code

Local $oExcel_1= _Excel_Open()
Local $sWorkbook="C:\Users\Tushar Verma\Desktop\AUTO IT\Test.xlsx"
Local $oWorkbook = _Excel_BookOpen($oExcel_1,$sWorkbook)
_ExcelSheetActivate($oExcel_1, "Test") ; I want to open this sheet (Test) but this will not open 

WinActivate($oWorkbook)
Sleep(3000)
$read1=_Excel_RangeRead($oWorkbook,Default,"A2")

 Thanks in advance !! 

[Subz]

Look at _Excel_BookAttach to attach to an open workbook

[Tushar]

@Subz

I want to open Particular sheet in current workbook not a different Workbook !

 

[Subz]

Sorry read your post wrong, you can just use _Excel_RangeRead and the second parameter would be the name of your work sheet.

[water]

_ExcelSheetActivate is a function of a very, very old version of AutoIt. The Excel UDF has been rewritten since and all functions renamed to _Excel_*. Some of them have been dropped.
Please see the AutoIt change history.

With activating a specific sheet you automate the Excel GUI. With the Excel UDF you use the COM interface. I suggest to not mix this two.
Use the correct UDF function for your goal and pass the sheet number or name to process as parameter.

What exactly do you want to do with the selected sheet?

[Subz]

If you want to activate a worksheet you can also use the $oWorkbook.Worksheets("Sheet1").Activate to make it the active sheet.  Example below:

#include <Array.au3>
#include <Excel.au3>

Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oExcel, @ScriptDir & "\Workbook.xlsx")
;~ Activate/Navigate to worksheet "Sheet1"
;~ nb: Not required to use _Excel_RangeRead
$oWorkbook.WorkSheets("Sheet1").Activate
;~ Read range A1:B4 on Sheet1
Local $aWorkbook = _Excel_RangeRead($oWorkbook, "Sheet1", "A1:B4")
_ArrayDisplay($aWorkbook)

 

[Tushar]

Thanks you soo much @Subz 😇