Save Active Document with automatic file name

Save Active Document with automatic file name

Post by btc » Tue, 31 Jan 2006 21:27:18



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.
 
 
 

Save Active Document with automatic file name

Post by Jay Freedm » Wed, 01 Feb 2006 01:02:02


See http://www.yqcomputer.com/
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).

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