How to select a workbook?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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
 
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
 

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

Similar Threads

How to do it in macro? 3
How to close excel worksheet after 15 mins? once it opened 5
How to disable a workbook? 1
What kind of workbook function should I used? 1
Unwanted workbooks on startup 2
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Select Previously Selected worksheet (and/or select previouslyselected workbook) 5

Back
Top