Hi All,

I'm struggeling with an easy question but i cannot find the answer. I want to read some data from an Excel sheet with multiple worksheets. Normally the sheet is saved on a different worksheet then the worksheet i need with my script. So when i open the file i need to activate the other sheet.
To open the file is use:
$exsheet = $workshare+"\klanten.xlsx"
$objexcel = CreateObject("Excel.Application")
$oke = $objexcel.workbooks.Open ($exsheet)

I tried to use: $objexcel.workbooks.Activate("Places")
but that does not work.

Does anybody know a good method for activating the correct worksheet?

Thanks!!!

Peter