How to switch between different workbooks?

[Ivan]

Hi,

If I want to switch between (activate) different opened excel workbooks,
what code should I use in VBA?
Thanks.

Ivan

[Norman Jones]

Hi Ivan,

> If I want to switch between (activate) different opened excel workbooks,
> what code should I use in VBA?

Perhaps I misunderstand but:

'=============>>
Sub Tester03()
Dim WB1 As Workbook, WB2 As Workbook, WB3 As Workbook

Set WB1 = Workbooks("Book1.xls")
Set WB2 = Workbooks("Book2.xls")
Set WB3 = Workbooks("Book3.xls")

WB2.Activate

End Sub
'<<=============

---
Regards,
Norman


"Ivan" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> If I want to switch between (activate) different opened excel workbooks,
> what code should I use in VBA?
> Thanks.
>
> Ivan

[Ivan]

Hi Norman,

Thanks a lot! It helps.

Ivan

"Norman Jones" wrote:

> Hi Ivan,
>
> > If I want to switch between (activate) different opened excel workbooks,
> > what code should I use in VBA?
>
> Perhaps I misunderstand but:
>
> '=============>>
> Sub Tester03()
> Dim WB1 As Workbook, WB2 As Workbook, WB3 As Workbook
>
> Set WB1 = Workbooks("Book1.xls")
> Set WB2 = Workbooks("Book2.xls")
> Set WB3 = Workbooks("Book3.xls")
>
> WB2.Activate
>
> End Sub
> '<<=============
>
> ---
> Regards,
> Norman
>
>
> "Ivan" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > If I want to switch between (activate) different opened excel workbooks,
> > what code should I use in VBA?
> > Thanks.
> >
> > Ivan
>
>
>