L
Legacy 336969
Guest
1) We have a program that creates a "New Worksheet" (csv) for me everyday with unique information. The name of the "New Worksheet" is always exactly the same.
2) I copy the "New Worksheet" information to my "Existing Worksheet".
3) The problem is that in my "Existing Worksheet" the links change when I close the "New Worksheet". So now when I create a "New Worksheet" the next day, it doesn't know to link to it.
This is an example of the link change: [='[52844_Activities_Export.csv]52844_Activities_Export'!$A$2] Changes To ='C:... \Temporary Internet Files\Content.IE5\C710XOCW\[52844_Activities_Export.csv]52844_Activities_Export'!$A$2
4) I would prefer not to use VBA to accomplish this task. Because I would link the links to be dynamic.
2) I copy the "New Worksheet" information to my "Existing Worksheet".
3) The problem is that in my "Existing Worksheet" the links change when I close the "New Worksheet". So now when I create a "New Worksheet" the next day, it doesn't know to link to it.
This is an example of the link change: [='[52844_Activities_Export.csv]52844_Activities_Export'!$A$2] Changes To ='C:... \Temporary Internet Files\Content.IE5\C710XOCW\[52844_Activities_Export.csv]52844_Activities_Export'!$A$2
4) I would prefer not to use VBA to accomplish this task. Because I would link the links to be dynamic.
