Switching between workbooks

Is there a way to switch back and forth between workbooks without having to use the Activate command? I have everything planned out but this aspect is still a source of confusion.

The Project:
I need to have qty purchased and price in a table from Worksheet B entered into the matching customer index location in Worksheet A. Worksheet B contains customer number, sku, qty purchased and price. Worksheet A contains customer numbers in row 3 and sku's in column A. Minor data manipulation will need to be done on Worksheet B before before accessing it which I plan to do after opening it in this macro.

If you use object variables to reference workbook/worksheet/range etc you should not need to switch between the 2.

I have not worked with assigning workbooks to variables and manipulating them as of yet. Is there a good reference for working with them or if you feel like it some small examples?

you code would be something like this,

Please Login or Register  to view this content.