Hi Robert,

Probably you can work with the workbook as an object. Either it is
thisworkbook, or you have to open (create) it, so you can set an object
variable:

dim wb as workbook
set wb=workbooks.open filename:="somebook"
wb.activate

Regards,
Ivan