How to create a macro saving document with current date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erick - 09 Jan 2006 22:01 GMT

Hi,

How can I create a Macro which will save my test.doc document in a given
directory "C:\briefing " like this: 20060109test.doc

Thanks for your help

Erick

Reply to this Message

Doug Robbins - Word MVP - 10 Jan 2006 05:18 GMT

ActiveDocument.SaveAs Format(Date, "yyyyMMdd") & ActiveDocument.Name

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi,
>
[quoted text clipped - 4 lines]
>
> Erick

Reply to this Message

Erick - 10 Jan 2006 21:41 GMT

Thank you very much indeed but it saves the document in "My Documents"
directory....
Any tips to save it in a particular DIR having the following path:
c:\test\briefing?

Many thanks

Erick

> ActiveDocument.SaveAs Format(Date, "yyyyMMdd") & ActiveDocument.Name
>
[quoted text clipped - 14 lines]
> >
> > Erick

Reply to this Message

Doug Robbins - Word MVP - 11 Jan 2006 05:07 GMT

Include the path in the following manner

ActiveDocument.SaveAs "Driveletter:\foldername\" & Format(Date, "yyyyMMdd")
& ActiveDocument.Name

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Thank you very much indeed but it saves the document in "My Documents"
> directory....
[quoted text clipped - 24 lines]
>> >
>> > Erick

Reply to this Message

Erick - 11 Jan 2006 19:40 GMT

Thank you very much for your input Doug.
It really helps me.

Best regards,

Erick

> Include the path in the following manner
>
[quoted text clipped - 37 lines]
> >> >
> >> > Erick

Reply to this Message