How to switch between different workbooks?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

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

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

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
'<<=============
 
Hi Norman,

Thanks a lot! It helps.

Ivan

Norman Jones said:
Hi Ivan,


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
'<<=============
Click to expand...
 
You must log in or register to reply here.

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

Switch Between Workbooks 4
How to append data from different sheet and different workbook? 2
switching between workbooks 8
How to open workbooks in different Excel? 2
Workbook name problem 2
Switch to Excel workbook in a separate instance of Excel 3
Spreadsheet calculation problem 3
Code to switch between workbooks 3

Back
Top