removing links between workbooks
Hello,
I have a macro which selects a number of sheets and exports them into a new file. One of the sheets is an admin sheet which contains information for the other sheets (links). However, even though I include this admin sheet in the selection for the new file, and it places the admin sheet in the new file, all of the other sheets reference the original file's admin sheet. Is there a way around this instead of me adding code to the macro to setup the links within the new spreadsheet? kind regards, Matt |
removing links between workbooks
Hello Matt,
This won't happen if you copy the sheets all at the same time e.g. Sheets(Array("Sheet2", "Sheet1")).Copy or ActiveWindow.SelectedSheets.Copy DQ |
All times are GMT +1. The time now is 10:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com