Apr 17, 2013 at 12:34 PM
Edited Apr 17, 2013 at 12:35 PM
Why don't you do a copy of your original template?
Keep the original, create a new one according from your template and only change what you need to be changed.
worksheetnumber helps me to go through each worksheets, that's why I increase it.
workSheet = (Excel.Worksheet)xlsApp.Worksheets[worksheetnumber];
workSheet is the current worksheet that I select, in your case, if you always do a modification on 1 worksheet, it should be
workSheet = (Excel.Worksheet)xlsApp.Worksheets;
But if you want only one specific worksheet to be changed, you can do it with a condition.
I was doing the same, opening a template and replacing images/tables/charts according to the one I import.