moving between workbooks

[dgkindy]

I am trying to copy data from one workbook to a new workbook. However, only know the name of the second workbook as people might change the name of the first workbook.

How do you reference workbooks so that you can move back and forth between them.

I thought it was

Please Login or Register  to view this content.

or Select

[Leith Ross]

Hello dgkindy,

You can assign object variables to each workbook. This example assumes the second workbook is the new one the data will be copied to and the VBA macro is in the first workbook.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[piyushdabomb]

In addition to Leith's response,

To reference workbooks by name instead, reference them by stating:

Workbooks("abc.xls").activate

That will activate abc.xls for example. To get to it, you could save the variable name as a string and refer to it whenever you need to.