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 ...

Here are some urls you could use to learn more about VB for word and excel

http://www.mathtools.net/Excel/VBA/
http://www.valdosta.edu/webct/help/wqif/
http://office.microsoft.com/downloads/2000/supmacros.aspx

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