Increment Quote Number only when save as completes successfully

D

Divercem

A small group of users want to create a form which increments the Quote
number only after they click a control button named cmdSaveQuote to avoid
losing Quote numbers if a user decides to cancel out of a quote. It is a
responsibility 1-2 people will share, but only 1 person at a time will be
responsible for the quotes, so very little code needs to be in place to avoid
duplicate quote numbers

Unfortunately, I've only scratched the surface for macros and vbs coding.
Any help would be greatfully appreciated.

Thanks in advance,

Charlie
 
D

Doug Robbins - Word MVP

Use a variation of the code in the article "Creating sequentially numbered
documents (such as invoices)" at:

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

In a macro named FileSaveAs
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top