Hi, I have been running into the well known sheet copy limitations (Run-time error '1004': Copy Method of Worksheet Class failed) as per kb articles http://support.microsoft.com/kb/210684 and http://support.microsoft.com/default.aspx?scid=kb;en-us;Q177634
My solution is to create a template (Example.xlt) and use the Sheets.Add Type:="Example.XLT" method rather than copying the template sheet within the workbook.
The template sheet is far too complicated to generate programmatically and needs to be flexible (changes every now and then).
The issue is that the template is required to link to cells already in the workbook and when I invoke Sheets.Add with the template, it opens every time and asks to update links - I can't work out how to suppress the dialog box 'Update links?'.
Does anyone have a nice solution for this?