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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top