I have a macro which adds sheets to a workbook (.xlsm) based upon a
custom template (.xltm). The line of code which does this is:
Sheets.Add Type:="<path>filename.xltm"
Doing so causes excel to create a link to the .xltm file. I can see
the link by going to Data ribbon, and clicking on Edit links in the
Connection group. I also tried doing this manually by inserting a
sheet based upon the template file and the same thing happens. Why?
This doesn't happen in Excel 2003. Is there a flag in Excel 2007 which
indicates I don't want a link back to the source file that I need to
set? This is either a new "feature" in Excel 2007 or a bug.....
- John.
Similar Threads
