Open an Excel Spreadsheet to a Specfic Worksheet

[Jody Baldwin]

Good Morning,

I have tried the following with no luck...

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

Any other ideas?

Thanks,

Jody

 

[Dave Peterson]

This worksheet formula worked ok for me:

=HYPERLINK("file:////c:/my documents/excel/book2.xls#sheet1!a1","click me")

 

[Gord Dibben]

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

 

[Jody Baldwin]

Thanks for your responses!

Jody