Open excel and having it open on certain sheet

  • Thread starter Thread starter ryan.fitzpatrick3
  • Start date Start date
R

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
 
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.
 
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.
 
Back
Top