book2 auto opened once book1 opened

******Millions thanks to Genius Bakerman2 for the most powerful, super quick code that works miraculously. Your super quick help is always greatly appreciated. I wish I could add all ** to your rep. God bless you all***



Thanks millions Bakerman2, MikeVol for your super quick codes. I do not have a chance to test the codes properly but I cant wait any longer to add reps to your super quick code, talent, your passion to help. All stars are banked to your reps as always regardless. I will keep you update for the proper test.
God bless you all.


Hi Super coders
Wishing you a sunny, happy weekend.
I urgently need your talent please.
I have 2 books, both are xmls.
I need VBA code for one of these books that when one book is opened, the other will also be opened.
both are in different drives? or is it required to be the same?
Thanks in advance for your help

In ThisWorbook module of Book1.

Please Login or Register  to view this content.

Hello @jojo4santa.
Paste the following code into the ThisWorkbook module of the Book1.xlsm workbook, save and close the file. Open it again and enjoy! In the code, you can specify the path to the Book2.xlsm workbook (read the comments in the code), or you can omit it, then the user will be asked to specify the path to the file. Otherwise, work will continue without the second (Book2.xlsm) file.

Please Login or Register  to view this content.

Good luck.

Did you put the code in the ThisWorkBook module of Book1, saved, closed and reopened Book1?

Did you read my Post#5?

You're welcome and thanks for rep+.

@jojo4santa.
Next time, read carefully what is written for you in the post! I understand that you need the macro code itself, but read the entire post! This is very important.