Save file with different name and dont update the links when opened again
Hi ,
Is there any macro which can help me save a file with a diferrent name
( time stamped ) and dont update the links later,
Actually my Template is linked to other data sources. And these data
sources are updated every month. After the data is updated, i want to
open the tmeplate , update it and save this updated template with a
differnet name Filename-dd-mm-yy.xls -
If i open this new file saved, it shoud not make any changes in the
data .
Is it possible to achive this target,
I would appreciate your help.
Thanks
Fatima
|