Software

Ask something
Discussion Locked

Weekly Auto Save As Current Date File

0 helpful
7 replies

by crispin_yuen

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

7 replies

by jas03

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

by crispin_yuen

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?

by crispin_yuen

Hi Jas

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

This discussion is closed to new replies.