VBA to run Macro after file has opened

[Excellover123]

Hello Message Board
I have a workbook (WB1) that has a Macro that goes & opens another file (WB2), copy the data & pastes it into WB1 then closes WB2.
Could this Macro run automatically after opening the file? I have tried to call my Macro within "Sub Workbook_Open()" but that doesn't seem to be working.
Kind regards.
Gary.

 

[Jimmypop]

Where are you putting the Code...Should go here..

.

 

[RoryA]

It must be in the ThisWorkbook module of the workbook or it will not run automatically.

 

[Excellover123]

Where are you putting the Code...Should go here..

.View attachment 78900

Thank you, Jimmy
That is certainly doing something, however, it's erroring on the part in yellow below?

 

[Excellover123]

It must be in the ThisWorkbook module of the workbook or it will not run automatically.

Thanks Rory

 

[Jimmypop]

What is the error description?

 

[Excellover123]

What is the error description?

Hi Jimmy.
It's showing

 

[Sparcot]

Hi Jimmy.
It's showing
View attachment 78905

Show also the project explorer window in the screenshot

 

[Excellover123]

Show also the project explorer window in the screenshot

Hi Sparcot - Is the below what you are looking?

 

[Sparcot]

Hi Sparcot - Is the below what you are looking?
View attachment 78907

Paste all code here

 

[RoryA]

Use Workbooks("Reports.xlsm") rather than Windows("Reports.xlsm")