Save file with different name and dont update the links when opened again

H

hamad.fatima

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
 
Top