Invoice Numbering

[Guest]

Hi
I would like to know if it is possible to use a template invoice and get the invoice numbers to generate sequentualy
001 - 2000 ect
with each new invoice opened having a new unique number

Thank you

 

[garfield-n-odie]

See http://www.word.mvps.org/faqs/macrosvba/NumberDocs.htm.

 

[Greg Maxey]

Herb,

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

 

[Guest]

That Macro wont compile corectly says else without i

 

[Graham Mayor]

It compiles fine here. The errant section is

If Order = "" Then
Order = 1
Else
Order = Order + 1
End If

which begins with the 'If' your compiler complains is missing. Have you
copied it correctly? Paste from the web page.

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

My web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>><

 

[Guest]

I have copy and pasted it ver batim still will not compile correctly I may have to reinstall office 200

----- Graham Mayor wrote: ----

It compiles fine here. The errant section i

If Order = "" The
Order =
Els
Order = Order +
End I

which begins with the 'If' your compiler complains is missing. Have yo
copied it correctly? Paste from the web page

--
<>><><<>><<><>><><<><>><<>>
Graham Mayor - Word MV

My web site www.gmayor.co
Word MVP web site www.mvps.org/wor
<>><><<>><<><>><><<><>><<>>



herb wrote

 

[Graham Mayor]

the problem seems to be that when a document is protected (to make
fillable fields) the macros will not work it cant seem to find the
bookmark for some reason. I tried with a feild and without

That's a different issue - here you need to lock the form *after* the macro
has run. You can include the commands to lock the form in the autonew macro

ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True


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

My web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>><

 

[Guest]

Thank You Very Muc