ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automated Copying without links (https://www.excelbanter.com/excel-programming/372480-automated-copying-without-links.html)

LoDawg

Automated Copying without links
 
I am working on an import routine for users to upgrade their exisiting
workbooks to the new version we are now using. During this procedure a
sheet template is copied from one workbook which only contains sheet
templates, to the workbook being created in the import routine.
Originally this was done internally within the wb under creation, but
excel could no longer copy the shet after 34 copies, and the workaround
microsoft suggests (saving, closing then reopening the wb) completely
breaks the import routine. So, after the import is finished and the wb
saved, the This workbook contains links....Do you want to update?
message appears. Is it possible to perform the copy procedure without
creating these links. If not how can I go about removing these links. I
have seen several mentions of other add-ins that will do it for you but
I would rather handle this in code myself than install and run aomeone
elses add-in. I think my boss would prefer this as well.



All times are GMT +1. The time now is 09:25 AM.

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