My pocedure opens a excel template file and add new worksheets using Worksheets.Add
In the template file I have a module and the procedure stops as I try to add a sheet in the template.
The procedure works perfectly well if in the template I do not have a module or code in the sheet or directly in one of the sheet.
I have exactly the same problem if I try to copy via VBA the main sheet in the template.
Many thanks