View Single Post
  #7   Report Post  
Posted to microsoft.public.word.docmanagement
Sync-opy Sync-opy is offline
external usenet poster
 
Posts: 5
Default Automatically date stamp filename when save?

Hi Graham,

After many months of using your Save Numbered Versions macro (it has been a
lifesaver!), I have one more question in terms of its alteration. I have
tried without success to accomplish this on my own. Basically, is there a
way to alter the code such that the saved file would be named in this manner:
Filename - Date Time - Version 00#
Instead of:
Filename - Version 00# - Date Time

I ask simply because when looking up the most recent file in my windows
folder, it would be easier to sort by name and have the most recent file at
the top or bottom of the list. As it is now, because the version # starts
over for each subsequent date I save, the list is sorted by Version # first,
the date, making it more difficult to easily pick out the most recent file.

In any case, this macro has made my life so much easier and I thank you!

Sync

"Graham Mayor" wrote:

Yes adding the time is easy enough.
Define another string at the start

Dim strTime As String

Then under the line
strDate = Format((Date), "dd MMM yyyy")
add
strTime = Format((Time), " hhmm")
then near the end locate and change the following lines thus:

'Define the new version filename
strVersionName = strPath & "\" & strFile & " - Version " & _
Format(iCount, "00#") & " - " & strDate & strTime & ".doc"

Do not use a colon between hours and minutes in the line strTime=


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Sync-opy wrote:
Thanks! That was exactly what I was looking for. I actually
navigated to and downloaded your add-in macros and I am using that.
One more question though: is it possible to have the filename include
the time of the save in addition to the date and version number?

Thanks again! this is so helpful compared to the other options!

"Graham Mayor" wrote:

The macro at http://www.gmayor.com/save_numbered_versions.htm will
do that. Do not use the master doc facility. It is fatally flawed
and will eventially corrupt your work.
Word can handle huge documents as single files.
--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Sync-opy wrote:
Is it possible to have Word automatically save a doc under a new
filename with a current date - time stamp automatically appear in
the new filename. I'm having difficulty juggling different versions
of a master doc and the "Save as version" option just isn't cutting
it.

Thanks!