tilamok
04-23-2011, 05:17 AM
Hi All
I'm having a strange problem at work.
I have an initial s/s A that has external links to several s/s including s/sB which is password protected & readonly
Using FSO's, I'm copying that initial s/sA to another folder and then changing a few cells using vba
However in that copied s/s, the values that are still linked to s/sB have reverted to some old values.
If I open s/sB and then run the macro that does the copy & update, then the values don't revert.
Does anyone know how to avoid values reverting to some old values?
Thanks
I'm having a strange problem at work.
I have an initial s/s A that has external links to several s/s including s/sB which is password protected & readonly
Using FSO's, I'm copying that initial s/sA to another folder and then changing a few cells using vba
However in that copied s/s, the values that are still linked to s/sB have reverted to some old values.
If I open s/sB and then run the macro that does the copy & update, then the values don't revert.
Does anyone know how to avoid values reverting to some old values?
Thanks