ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding Sheet using Template creates link (https://www.excelbanter.com/excel-programming/418838-adding-sheet-using-template-creates-link.html)

[email protected]

Adding Sheet using Template creates link
 
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:="<pathfilename.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.


All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com