Assign the name of the workbook to a variable?

I need to find a way to always re-select the 'original workbook' after having selected and activated other workbooks / documents.

The name of my 'original workbook' changes everytime, so I thought I might be able to work around it by assigning the name of that original workbook to a variable.

Any help much appreciated

Hi

How are you going to determine the "original workbook"?

If it is the workbook that contains the macro, then you can use

Please Login or Register  to view this content.

. If not, then you need to have some way to determine which workbook you want to use.

rylo

It is almost never necessary to actually select or activate other workbooks in code, but the simple way to do what you want I think is to use a workbook variable:

Please Login or Register  to view this content.