| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select a workbook?
I open two workbooks at the same time, and would like to setup a macro to
select workbook "mybook.xls", and bring it into the upfront. Does anyone have any suggestions on how to do it in execl? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to select a workbook?
Workbooks("mybook.xls").Activate
-- Regards Dave Hawley www.ozgrid.com "Eric" wrote in message ... I open two workbooks at the same time, and would like to setup a macro to select workbook "mybook.xls", and bring it into the upfront. Does anyone have any suggestions on how to do it in execl? Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to select a workbook?
Or use GoTo;
Application.GoTo Workbooks("mybook.xls").Sheets(1).Range("A1") -- Regards Dave Hawley www.ozgrid.com "ozgrid.com" wrote in message ... Workbooks("mybook.xls").Activate -- Regards Dave Hawley www.ozgrid.com "Eric" wrote in message ... I open two workbooks at the same time, and would like to setup a macro to select workbook "mybook.xls", and bring it into the upfront. Does anyone have any suggestions on how to do it in execl? Thanks in advance for any suggestions Eric |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to select a workbook?
hi
Workbooks("mybook.xls").Activate after that you may need to do more selecting. sheets("sheet1").activate range("A1").select or Cells(1,1).select regards FSt1 "Eric" wrote: I open two workbooks at the same time, and would like to setup a macro to select workbook "mybook.xls", and bring it into the upfront. Does anyone have any suggestions on how to do it in execl? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select different workbook in vba? | Excel Programming | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| workbook select | Excel Discussion (Misc queries) | |||
| Sheets select method fails when workbook is opened by another workbook | Excel Programming | |||
| Select other workbook to select data in a macro. | Excel Programming | |||
Hybrid Mode
