Scope - referring to subroutines within other projects

[Stoffel24]

I have an excel spreadsheet that is based on a template. When I open this file, I see there are 2 projects - one for the original template (called "querytag.xls (Querytag.xla)&quot and another for the file itself called "VBA Project (ML_Sandy.xls)" I want to be able to call a subroutine in the VBA Project from the QueryTag project. Can this be done? I would love to know how.

Thanks
Scott

 

[asjeff]

Try:

Application.run "Macro name"

Is dependent upon being a public procedure.

Asjeff