| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a specific sheet with VBA
Hi I was wondering what the VBA code was for opening a specific sheet in
another unopen workbook. For example from one workbook I want to open sheet6 on another one my code is beneath Workbooks.Open "\\Kerrygriffit-pc\external\Other\Money\New Going out Sheet V2.xls\february" Thanks Joel -- N/A |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open a specific sheet with VBA
One way:
Workbooks.Open "\\Kerrygriffit-pc\external\Other\Money\New Going out Sheet V2.xls\february" ActiveWorkbook.Sheets("Sheet6").Activate In article , Joel wrote: Hi I was wondering what the VBA code was for opening a specific sheet in another unopen workbook. For example from one workbook I want to open sheet6 on another one my code is beneath Workbooks.Open "\\Kerrygriffit-pc\external\Other\Money\New Going out Sheet V2.xls\february" Thanks Joel |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open a specific sheet with VBA
After your Workbooks.Open insert:
Sheets("sheet6").Activate -- Gary''s Student - gsnu200753 "Joel" wrote: Hi I was wondering what the VBA code was for opening a specific sheet in another unopen workbook. For example from one workbook I want to open sheet6 on another one my code is beneath Workbooks.Open "\\Kerrygriffit-pc\external\Other\Money\New Going out Sheet V2.xls\february" Thanks Joel -- N/A |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| open workbook to specific sheet | Excel Worksheet Functions | |||
| How do I open a workbook in a specific sheet | Excel Discussion (Misc queries) | |||
| Open Specific Sheet in Workbook | Excel Programming | |||
| Go to a specific sheet on open | Excel Programming | |||
| Auto Open Excel at Specific Sheet | Excel Programming | |||
Linear Mode
