How to access another workbook's ThisWorkbook

Hello everyone, this is my first post!

I am trying to make some code to copy a module from my add-in, to the active workbook's ThisWorkbook module. I can't seem to figure out how to access it though. Here's the code I'm using:

Please Login or Register  to view this content.

Thanks!

Assuming the Target Workbook is being opened by the code, I'd suggest you set an object/workbook variable that refers to it. Then use that workbook variable to full qualify the end point rather than ActiveWorkbook.

But how would that variable reference its own ThisWorkbook if the code is still being run in the add in? Is there a way to do something along the lines of ActiveWorkbook.ThisWorkbook?

Originally Posted by InvisibleMan

Assuming the Target Workbook is being opened by the code, I'd suggest you set an object/workbook variable that refers to it. Then use that workbook variable to full qualify the end point rather than ActiveWorkbook.

But how would that variable reference its own ThisWorkbook if the code is still being run in the add in? Is there a way to do something along the lines of ActiveWorkbook.ThisWorkbook?

ThisWorkbook is always the workbook running the code which, presumably, is the Add-in? The ActiveWorkbook is the workbook that is currently active/selected/in focus/ however you want to describe it. So, no, there isn't a concept of ActiveWorkbook.ThisWorkbook.

You might, for example, have something like this:

Please Login or Register  to view this content.