How do I select a Worksheet in Excel

[martmeister]

I have looked under help and couldnt find the answer I was looking for. I know this is probably a really easy answer but I was needing to know how to select a worksheet in Excel if you have multiple worksheets. Thanks a lot

[enaiman]

Help file quote:

  Quote

_ExcelSheetActivate

--------------------------------------------------------------------------------

Activate the specified sheet by string name or by number.

#Include <Excel.au3>

_ExcelSheetActivate($oExcel, $vSheet)

Parameters

$oExcel An Excel object opened by a preceding call to _ExcelBookOpen() or _ExcelBookNew()

$vSheet The sheet to activate, either by string name or by number

Return Value

Success: Returns 1

Failure: Returns 0 and sets @error on errors:

@error=1: Specified object does not exist

@error=2: Specified sheet number does not exist

@error=3: Specified sheet name does not exist

Read the help file - there is plenty about working with Excel workbooks.

[Juvigy]

Or you can use :

oExcel = ObjCreate("Excel.Application")
$oExcel.Visible = 1
$oExcel.WorkBooks.Open ("full path filename")
$oExcel.Sheets ("sheet name" ).Select

[MrCheese]

Is there a new way based on the current UDF?

[water]

You can find the difference between the "old" and "new/current" version of the Excel UDF in th help file.

Function _ExcelSheetActivate has been removed. You specify the sheet you want to process as parameter when calling a function.

[MrCheese]

Understood - shame,as i'm still having trouble with the function as per: 

 

[water]

You can still select the sheet "by hand". 

$oWorkbook.Sheets(<number or name>).Activate

I will check your other thread as soon as I return from my business trip. 

[MrCheese]

arrr! wasn't aware of that trick.

Excellent - I will give that a go.

 

And when you can - no rush really! Enjoy your trip.

[MrCheese]

I got it working with your suggestion.

thanks for your help!

[water]