Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inporting and Deleting Sheets
I have a macro that deletes old sheets from a master workbook and imports the
new sheets containing the updated information. In the master workbook, I have links to each sheet and when they are delete the old sheets, the link goes away as well. The new sheets are in the exactly the same format so if the previous links did work, it would pull the right information. Is there a way (other than using code to reset the links) to keep the links active as sheets delete and are replaced? Thanks for your help! Brennan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inporting and Deleting Sheets
Consider not deleting the old sheets and replacing with new sheets. How
about just refreshing the data in the sheets with data from the most recent sheets. (import the data, not the sheets) -- Gary''s Student - gsnu200785 "Brennan" wrote: I have a macro that deletes old sheets from a master workbook and imports the new sheets containing the updated information. In the master workbook, I have links to each sheet and when they are delete the old sheets, the link goes away as well. The new sheets are in the exactly the same format so if the previous links did work, it would pull the right information. Is there a way (other than using code to reset the links) to keep the links active as sheets delete and are replaced? Thanks for your help! Brennan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inporting and Deleting Sheets
When you delete those sheets the links are gone...permanently! You will have
to come up with some other method of refreshing, or resetting, the data in those linked sheets. What is the data source? Why don't you activate the sheet that the data is imported into, and use some basic code like this: Sheets("Sheet1").Select Cells.Select Selection.ClearContents '...other stuff down here... Regards, Ryan--- -- RyGuy "Gary''s Student" wrote: Consider not deleting the old sheets and replacing with new sheets. How about just refreshing the data in the sheets with data from the most recent sheets. (import the data, not the sheets) -- Gary''s Student - gsnu200785 "Brennan" wrote: I have a macro that deletes old sheets from a master workbook and imports the new sheets containing the updated information. In the master workbook, I have links to each sheet and when they are delete the old sheets, the link goes away as well. The new sheets are in the exactly the same format so if the previous links did work, it would pull the right information. Is there a way (other than using code to reset the links) to keep the links active as sheets delete and are replaced? Thanks for your help! Brennan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inporting JPEGs | Charts and Charting in Excel | |||
Deleting Custom Views when Deleting Sheets | Excel Programming | |||
CSV file for inporting contact list from Hotmail to Gmail using Ex | Excel Discussion (Misc queries) | |||
deleting sheets | Excel Discussion (Misc queries) | |||
Inporting data from a group of .prn files | Excel Programming |