Adding another VBProject as Reference

[high42]

Hello! I have 2 files. File A will open FIle B at some point through code. I need file B to open and add the VBProject in file A as a reference. At the same time I need File B to remove that reference on the BeforeClose event.

Both files are .xlsm and have their own VBproject


I tried:

Thisworkbook.VBProject.AddFromFile [FileName]

But I couldn´t make it work. Any suggestions?