Open excel and having it open on certain sheet

[ryan.fitzpatrick3]

I have this excel code

Dim objExcel As Object
Select Case Me!List1
Case "Supply Flour"
Set objExcel = New Excel.Application
objExcel.Workbooks.Open "C:\Documents and Settings\rfitz03\Desktop
\RYAN'S EXCEL SHEETS\Strategic Sourcing\Forms\Position Sheet\Flour
Position Sheet 2008.xls"
objExcel.Visible = True
End Select

is there away to have it open up Sheet1 upon selection?

ryan

 

[Elvis72]

The Excel Spreadsheet should open on what ever page you saved it on.

So if you are on Sheet 3 when you save then it will open to Sheet 3.

 

[ryan.fitzpatrick3]

That's not what I meant, I mean if you save it on sheet 3 and close it
and reopen it up, the code will make it open on sheet 1.