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

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

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