Access Multiple sheets in Excel

[mharcourt]

I need a little help in accessing different sheets in Excel.
I have scripts to open and retrieve cell contexts located on the first sheet. How do I move to the next sheet?

 

[SkipVought]

Hi

set wbk = [i]you Excel workbook object[/i]
for each ws in wbk.worksheets
  with ws
    'do stuff to worksheet, [b]ws[/b] as the object reference
     .Cells(1, 1).Value = "Hello"  'put Hello in A1 in sheet ws
  end with
next

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]

 

[mharcourt]

Thanks
You'll have to hold my hand on this one.
What I have so far is :
Set objXL = WScript.CreateObject("Excel.Application")
objXL.Visible = FALSE
objXL.Workbooks.Open(<path to xls file>)

Where does "set wbk = you Excel workbook object" fit in?

 

[SkipVought]

set wbk = objXL.Workbooks.Open(<path to xls file>)

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]

 

[mharcourt]

Thanks.
working great.

 

[SkipVought]

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]