| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I run a macro from a .xlt file
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I run a macro from a .xlt file
make your workbook a normal workbook rather than a template.
-- Regards, Tom Ogilvy "Vinnie" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I run a macro from a .xlt file
Thanks Tom, however for the purposes of this project I need to keep the files as templates. Any other suggestions?
"Tom Ogilvy" wrote: make your workbook a normal workbook rather than a template. -- Regards, Tom Ogilvy "Vinnie" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I run a macro from a .xlt file
Sure, understand how templates work and code accordingly.
-- Regards, Tom Ogilvy "Vinnie" wrote in message ... Thanks Tom, however for the purposes of this project I need to keep the files as templates. Any other suggestions? "Tom Ogilvy" wrote: make your workbook a normal workbook rather than a template. -- Regards, Tom Ogilvy "Vinnie" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Macro to Open File, Delete Contents, Save New File | Excel Discussion (Misc queries) | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro to pull data from another file - update name of file | Excel Discussion (Misc queries) | |||
| Macro to insert values from a file and save another sheet as a .txt file | Excel Programming | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
Linear Mode
