adding template

I have a VBS script attached which creates a workbook with named worksheets based on an excel file called 'Names". I want a template inserted into each worksheet the script creates. Please see attached files.

I think you want to put the WOW-example.xls Sheet1 into each Sheet created for every student. If that's the case, then you need to add a variable for the template, open the template, then do a copy from

I think you want to put the WOW-example.xls Sheet1 into each Sheet created for every student. If that's the case, then you need to add a variable for the template, open the template, then do a copy from the template into the Student worksheet, as each sheet is created.

See the modified code, below:

I've also attached 3 files. One for names that I made up, one for the template, and one for the output student sheet

Featured Post

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script. Many of these have come from the web or adaptations from snippets I find on the Web. Periodically I add to them when I come…