Opening a specified sheet in an Excel file

B

BarryHNZ

I am wanting to open a specified sheet in an excel file using START, RUN
command

So far I can open the first sheet but this is probably by default using the
command
"C:\Program Files\Microsoft Office\OFFICE11\Excel.exe" c:\students.xls
Is there a way to open just sheet 2?
 
M

Mike H

Hi,

You can make sheet 2 the active sheet

Workbooks.Open Filename:="C:\student.xls"
Sheets("Sheet2").Select

Mike
 
J

Jim Thomlinson

Opening an XL file is an all or none proposition. You can not just open one
sheet. You must open the entire workbook. You could use code to make the
sheet the active sheet on open but that will require enabling macros or
having the security set to Low.
 
B

BarryHNZ

Mike, are you suggesting code like
"C:\Program Files\Microsoft Office\OFFICE11\Excel.exe" Workbooks.Open
Filename:="C:\student.xls"Sheets("Sheet2").Select

I cannot get it to work
 
Top