Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We're developing an invoice template for Word, which contains an invoice number in a field at the top of the page.

We would like the invoice number to auto-increment (from the last invoice number), and we would like the filename to be based on the invoice number.

They'll all be saved in the same directory.

share|improve this question
I do not understand why someone has down voted you; this question is no worse than many others. Your question implies you hope to do this all in Word. I would use Access (which has auto-increment) so I could pull in things like customer name and address from tables and keep a usable record of my invoices. Finally I would output to Word if that was how I wanted to print my invoices. – Tony Dallimore Jan 24 '12 at 11:51
@TonyDallimore Some people are judgemental nazis, myself probably included... :-P – Steve Jan 27 '12 at 2:35
@Tony/Steve: I think it may have been voted down as the tone is as though someone is simply asking a forum member to make it for them. I posted a question where someone pointed this out to me, and I get it now. Post a question but don't treat people on here like their your butler. No offence. – RocketGoal Jan 27 '12 at 16:57
@Mike. I see your point. I did not read the question that way although, on reflection, with the remarks about filenames and use of a single directory perhaps I should have. I read it as a question about auto-incrementing in Word. I can think of some very clumsy ways of doing so but as I said I would not even try. To me, this looks to be an easy Access macro. – Tony Dallimore Jan 27 '12 at 17:23
up vote 0 down vote accepted

I found this which I think will solve the problem.

share|improve this answer
I said I could think of clumsy ways of doing this so I am pleased your website didn't recommend a smooth way that I had overlooked. Good luck if you can make this work but I still think this is a really difficult way of achieving your objective. – Tony Dallimore Jan 30 '12 at 11:53
10 seconds to copy and paste the macro, and the only pitfall is a text file is required to store the incremental number. Not difficult at all. Not intellectually elegant, but it works fine. – Steve Jan 31 '12 at 12:49

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.