sequential saving of document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Finlay - 29 Feb 2004 04:17 GMT

Hi All,

I am designing a "Non-Conformance report" from word. I'd like my team
members to open this file, type the information in, automatically print
after the last cell has been selected, then save automatically (as the next
sequential number we actually type into the report) and saved in the folder
where the reports are stored.

eg. therefore, if we enter a number, say 1111, into the "report #" field I
would like the file to be saved as NonCon1111.doc. Would anyone be able to
help me create this macro? (please keep in mind that my computer programming
skills arn't as great as everyone else's in here!) If you would like the
template i can send it to you to try out??

Thankyou everyone.

Kind regards

Peter Finlay

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 29 Feb 2004 08:16 GMT

Hi Peter,

See the article ?Creating sequentially numbered documents (such as
invoices)? at:

http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm

The code in that macro can easily be modified to save the document with the
filename NonCon+Number.doc.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

> Hi All,
>
[quoted text clipped - 20 lines]
>
> Peter Finlay

Reply to this Message