| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening a specified sheet in an Excel file
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Opening a specified sheet in an Excel file
Hi,
You can make sheet 2 the active sheet Workbooks.Open Filename:="C:\student.xls" Sheets("Sheet2").Select Mike "BarryHNZ" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Opening a specified sheet in an Excel file
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 "Mike H" wrote: Hi, You can make sheet 2 the active sheet Workbooks.Open Filename:="C:\student.xls" Sheets("Sheet2").Select Mike "BarryHNZ" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Opening a specified sheet in an Excel file
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. -- HTH... Jim Thomlinson "BarryHNZ" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| opening a file in Excel starts application but dose not open file | Excel Discussion (Misc queries) | |||
| HOW TO LOCK/STOP THE OPENING OF 1 SHEET AMONG 3 IN 1 EXCEL FILE? | Excel Discussion (Misc queries) | |||
| Opening file in Excel 2003 opens multipule instances of same file | Excel Discussion (Misc queries) | |||
| Spread sheet calculating/not calc from opening file differently | Excel Worksheet Functions | |||
| opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Hybrid Mode
