Copy template worksheet from macro file to the working file

Hello,

I am working on a macro that should copy a template (complex voucher) to an Excel file/report generated by a software.

Basically the template will be located in the file "Macro.xls/xlsx". The sheet name is "Template". Once the user exports the report from the software (lets say that the exported file will be named "book1") I would like when the macro is run to copy the "Template" sheet from the file "Macro" into the file "book1" as a second sheet (or last sheet does not matter as long as it is copied there).

I do not know if it is important but the template has defined print area which I would like to be preserved.

I hope that I was clear. Is there an easy way to just copy the Template sheet from "Macro" to "book1" Excel files?

Thank you so much.

Edit: if the path to the files is important than they can both be located in one folder. Even in the root C:\ directory. This is really no problem.

I would like to apologize for opening this thread which probably seems trivial to most of the members on this forum. I was lost in many explanations on the net and could not see the forest from the tree.

http://support.microsoft.com/kb/288402

Thank you so much.