How do I run a macro from a .xlt file

[Guest]

My program (Test.xlt) has code which opens another workbook (Calc.xlt) & then runs a macro from Calc.xlt.
My problem is that everytime the code runs, Calc.xlt opens as Calc1 & the next time as Calc2 & then Calc3 etc. This means the macro from within isn't recognised because my code refers to Openfile - Calc.xlt. and not Calc1, Calc2 etc.

How do I amend my code so that when Calc.xlt is opened, the macro is recognised as Calc1!RunMacro or Calc2!RunMacro or Calc3!RunMacro

Thanks

 

[Tom Ogilvy]

make your workbook a normal workbook rather than a template.

--
Regards,
Tom Ogilvy

My program (Test.xlt) has code which opens another workbook (Calc.xlt) &

then runs a macro from Calc.xlt.

My problem is that everytime the code runs, Calc.xlt opens as Calc1 & the

next time as Calc2 & then Calc3 etc. This means the macro from within isn't
recognised because my code refers to Openfile - Calc.xlt. and not Calc1,
Calc2 etc.

How do I amend my code so that when Calc.xlt is opened, the macro is

recognised as Calc1!RunMacro or Calc2!RunMacro or Calc3!RunMacro

 

[Guest]

Thanks Tom, however for the purposes of this project I need to keep the files as templates. Any other suggestions?

 

[Tom Ogilvy]

Sure, understand how templates work and code accordingly.

--
Regards,
Tom Ogilvy

Thanks Tom, however for the purposes of this project I need to keep the

files as templates. Any other suggestions?