Cannot paste into an non-active workbook

Dear All,

I am trying to paste from an active workbook(2) into an open workbook(1)

I first tried it with activiating workbook(1) and then succesfully pasted. Then I tried it without activating workbook(1) which failed.

I would appreciate knowing if this is even possible and if so how?

My attempt at this is in the workbook(2) macro

Thanks John