View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Template Functionality

Hi All
I have developed an application and saved this as a template file. A
separate loader programme opens this template and populates a number of
sheets in the template and saving the template as a 'normal' workbook with a
new name. This process in repeated 15 times for different datasets. My
question concerns how does a template (xlt) file differ from a normal wks
file?

In my template I have some macros required for the final application,
including a workbook open event. I was under the impression that the
template would not run its macros upon opening - it clearly does! - how do
I disable the macros in the template so that they only run when it is saved
as an wks workbook?

--
Cheers
Nigel