Word Macro - auto increment invoice number and file name on save

Question

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.

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.
@TonyDallimore Some people are judgemental nazis, myself probably included... :-P
@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.
@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.

Steve · Answer 1 · 2012-01-27 05:15:26Z

up vote 0 down vote accepted

I found this which I think will solve the problem.

answered Jan 27 at 5:15

Steve
1,160523

	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 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 at 12:49

feedback

1 Answer