automation of adding ref number

[Kevin J Prince]

Hi All,

I need to write a small vba macro, to enable the following.
(Both 2003 and 2007)

Open a template, insert a reference number (one up each time) and save
the file (before it's been edited)
To be saved in the same directory each time (guess what called quotes).

File ref number to be incremented every time the macro is run. In the
following format.
RSTU-xxx-xxxxx

RSTU will be the inits of the user
xxx will be the day count
xxxxx will be the incremented ref number.

The reference number will be held on a server so that the adapted macro
(for each user) will always be taking the number from there.

Any help much appreciated.

Kevin

 

[Graham Mayor]

The code required is essentially that at
http://www.gmayor.com/automatic_numbering_documents.htm and
http://www.gmayor.com/save_numbered_versions.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Kevin J Prince]

Thanks for that, I hope I'll be able to follow it and implement it this
evening.

Regards

Kevin