Open an Excel Spreadsheet to a Specfic Worksheet

  • Thread starter Thread starter Jody Baldwin
  • Start date Start date
J

Jody Baldwin

Good Morning,

I have tried the following with no luck...

c:/yourfolder/book1.xls#'sheet1'!A1

Any other ideas?

Thanks,

Jody
 
This worksheet formula worked ok for me:

=HYPERLINK("file:////c:/my documents/excel/book2.xls#sheet1!a1","click me")
 
Cannot be done via Command as you are attempting.

Sheets cannot be selected to open, only workbooks.

To open at a specific sheet you would need VBA like

Private Sub Workbook_Open()
Sheets("Sheet3").Activate
End Sub

Pasted into Thisworkbook module of the workbook being opened via the startup
command switch.

C:\yourpathto\book1.xls


Gord Dibben MS Excel MVP
 
Back
Top