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.

 

[Sparcot]

Hello. Place the code in Thisworkbook.

Private Sub Workbook_Open()
    'Call your_macro_name
End Sub

 

[Excellover123]

Hello. Place the code in Thisworkbook.

Private Sub Workbook_Open()
    'Call your_macro_name
End Sub

 

[Excellover123]

Hello Sparcot
I have tried this but unfortunately, it's not working either.
Kr, Gary

 

[Sparcot]

Hello Sparcot
I have tried this but unfortunately, it's not working either.
Kr, Gary

Show the code you've tried

 

[Excellover123]

Show the code you've tried

Hi Sparcot, here's the code.

 

[Sparcot]

Hi Sparcot, here's the code.

View attachment 78897View attachment 78898

Call CopyAndPasteInfo

 

[Excellover123]

Call CopyAndPasteInfo

Hi Sparcot. Just tried that & unfortunately that's not working either

 

[RoryA]

Where did you put the Workbook_Open code? (You don't need Call there - it makes no difference)

 

[Excellover123]

Where did you put the Workbook_Open code? (You don't need Call there - it makes no difference)

Hi Rory
The Workbook_open code is it's own module currently
Kr, Gary