View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] hamad.fatima@gmail.com is offline
external usenet poster
 
Posts: 19
Default 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