Assigning variable to open workbook

Hello

I want to create a report that pulls in data from a shared workbook containing multiple worksheets.
Unfortunately I'm stumbling fairly early as I can't set the variable to refer back to the original file containing the data once it has been opened. Basically I need to be able to toggle between two workbooks but the name of one will vary every time it is used to create the report. Code is as follows:

Please Login or Register  to view this content.

Works OK to this point but doesn't go back to file opened at step 1 above but stays in current as this is now deemed to be the active workbook


Thanks in anticipation

You don't use:

Please Login or Register  to view this content.

for example as THISWB is a workbook object, not the name of a workbook. It's just:

Please Login or Register  to view this content.

It is however almost never necessary to actually activate or select anything in code.

Based on your posted sample:

Please Login or Register  to view this content.