General discussion

Locked

Weekly Auto Save As Current Date File

By crispin_yuen ·
Hello

How do I automatically save a file A into Today'sDate file name on a weekly basis?

Specifically, for example: A word file. Can I create a VBA programme to be resident in the doc file? That way, it will auto save itself as different file name (currentDate.doc) into a pre-define folder. The currentDate should be named that of the day it is done. This should go on in continuing cycle.

Every week, I have to save a file from one place to another folder and update the file with a current date. I like to automate it.

Pls advise. Thank you.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Weekly Auto Save As Current Date File

by Jas03 In reply to Weekly Auto Save As Curre ...

you can use a batch file that compresses the files you want into a file with the current date
for example (using rar.exe that comes with winrar www.rarsoft.com)

rar a -ag -t date c:\documents
this will make a compressed file with all the documents under the folder c:\document with the name of date20030410.rar
I hope that helps

Collapse -

Weekly Auto Save As Current Date File

by crispin_yuen In reply to Weekly Auto Save As Curre ...

Thanks for your reply. Instead of using Rar, can I use MS Scheduler to automatically save it on a weekly basis? I don't want to run a batch file. I like it to be automated in the word file. Can I embed with VBA programme?

Collapse -

Weekly Auto Save As Current Date File

by Jas03 In reply to Weekly Auto Save As Curre ...

You can certainly do it with a vb script. you can find vbs example on the microsoft site
http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001169

good luck

Collapse -

Weekly Auto Save As Current Date File

by crispin_yuen In reply to Weekly Auto Save As Curre ...

Hi Jas

Thank you for your reply. I got a broken link in MSDN. Can you advise on the URL you gave? Thank you.

Collapse -

Weekly Auto Save As Current Date File

by Jas03 In reply to Weekly Auto Save As Curre ...
Collapse -

Weekly Auto Save As Current Date File

by crispin_yuen In reply to Weekly Auto Save As Curre ...

Poster rated this answer

Collapse -

Weekly Auto Save As Current Date File

by crispin_yuen In reply to Weekly Auto Save As Curre ...

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums