Prev: selection.copy = "picture too large"
Next: Help with this code please !!!!!!!
From: Eric on 13 May 2010 22:39
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
From: ozgrid.com on 13 May 2010 23:03
Workbooks("mybook.xls").Activate



--
Regards
Dave Hawley
www.ozgrid.com

"Eric" <Eric(a)discussions.microsoft.com> wrote in message
news:BC826E5F-2C11-4583-9280-9574E2BBC9C4(a)microsoft.com...
>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

From: FSt1 on 13 May 2010 23:16
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
From: ozgrid.com on 13 May 2010 23:24
Or use GoTo;

Application.GoTo Workbooks("mybook.xls").Sheets(1).Range("A1")




--
Regards
Dave Hawley
www.ozgrid.com
"ozgrid.com" <dave(a)ozgrid.com> wrote in message
news:%23UR4bIx8KHA.3880(a)TK2MSFTNGP04.phx.gbl...
> Workbooks("mybook.xls").Activate
>
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
>
> "Eric" <Eric(a)discussions.microsoft.com> wrote in message
> news:BC826E5F-2C11-4583-9280-9574E2BBC9C4(a)microsoft.com...
>>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
>

 | 
Pages: 1
Prev: selection.copy = "picture too large"
Next: Help with this code please !!!!!!!