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

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

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

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