Save Active Document with automatic file name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

btc - 30 Jan 2006 12:27 GMT

Hi

I want to create code/macro that saves a document to a specific fil
directory (eg c:\mydocuments\matters\"") and then gives it an automati
name using a numbering convention (eg format(date, "ddmmyy")
"username" & automatic number). I want it to look for the last numbe
saved and then save the new doc with the next number available. (e
file is called 300106da123 [da being username] and then next user save
and gets 300106bc124).

Thank you for your help.

Reply to this Message

Jay Freedman - 30 Jan 2006 16:02 GMT

> Hi
>
[quoted text clipped - 8 lines]
> Thank you for your help.
> B

See http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm for the part about
the sequential number.

It looks like you have the expression needed for the rest of the file name,
assuming you have some way to determine the current user name (and don't use
quotes around "username" unless you want that literal word in the file
name).

Signature

Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Reply to this Message