ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Save file with different name and dont update the links when opened again (https://www.excelbanter.com/excel-discussion-misc-queries/127755-save-file-different-name-dont-update-links-when-opened-again.html)

[email protected]

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



All times are GMT +1. The time now is 08:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com