Hard to say if macropod solution is what you need. You do not state the actual steps involved. If the template start with NO spreadsheet, then my suggestion may work for you. Record how to bring in the spreadsheet, and add that to your DocumentNew() of the template. Use the path string I posted in the code to bring in the spreadsheet.



You can now copy the template to any folder. When you use it to create a new document, it will bring in the spreadsheet from the folder that specific template file is in.

IMPORTANT! You should add some error trapping to make sure that things are handled well if the spreadsheet is NOT present.