I've created an automated drawing of an assembly driven by external design tables. I enter the driving parameters into a macro-enabled workbook (separate from the design tables) and press a button that updates the design tables and opens the drawing in SolidWorks, fully updated. I then have a macro in SolidWorks I use directly after that to take care of a few extra things like controlling scale, updating the BOM, and, most importantly, pack and go. The drawing that the excel macro opens is what I call the "master drawing", which changes each time a new assembly configuration is created. The pack and go macro in SolidWorks then, among other things, stores that particular configuration of the assembly in another folder, free from future changes in the master drawing.

Basically, what I would like to do now is make it a 'one-click' process rather than the two clicks it is now by somehow connecting the running of the excel and SolidWorks macros. The two ways I can think of to do this are:

     1. Run the SolidWorks macro from my excel macro (not sure if this is possible)

     2. Autorun the SolidWorks macro upon opening the "master drawing" by somehow monitoring for the event of opening its specific filepath (I'm pretty sure this is possible)

I have basic knowledge of VBA.

I apologize for the lengthiness, and thanks in advance for any advice!