Add reference libraries to excel application scope


I am trying to execute an excel macro within the excel application scope.

However, the macro requires certain excel reference libraries to run; using excel application scope does not load those libraries by default.

Is there a way to change the default libraries loaded into Excel application scope, or is there any other workaround?

Thanks, YP