Is there a way to create a macro that, when I open workbook 1, it will then automatically open workbook 2.

The reason for this is that I have a workbook 1 that is referencing another workbook 2, but in order for it to do so the other workbook 2 must be open. Workbook 2 will be constantly updated and needs to be in a seperate workbook from workbook 2.

I have created a macro to open the file, I just don't know how to make it open Workbook 2 automatically, right when I open Workbook 1


Hope this makes sense.

thanks

Lukas