Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 04-14-2009, 04:01 PM
alanda alanda is offline
Registered User
 
Join Date: 15 Dec 2008
Location: hanover
Posts: 34
alanda is becoming part of the community
Question Creating sequentially numbered form using Word 2007

Please Register to Remove these Ads

Currently we have rental forms that get filled out everytime one of our rental vehicles gets rented. In the past these forms have come pre-numbered from a local printing company. To save the company money, I was going to re-create the form in Word so that we didn't have to order them. Also, this way the form will look much tidier as the information will not have to be handwritten in. The only problem is, how do I add a sequential number to the top of the form. I need the first form to be say 03101, and then everytime the form is opened and saved thereafter, I need it to sequentially go up in numbers.
If this is even possible, I would only like it to give it the next number if the form is actually saved, not just opened, as sometimes the form will be opened, but not saved, and in that case I don't want it to get the next number.
Unfortunately, I am an amateur when it comes to VBA code. Could someone show me how to write this code, and how to put it into the document.?

Any help would be much appreciated

Alanda
Reply With Quote
  #2  
Old 05-19-2009, 10:17 AM
mark_jam3s mark_jam3s is offline
Registered User
 
Join Date: 12 Jun 2008
Posts: 7
mark_jam3s is becoming part of the community
Re: Creating sequentially numbered form using Word 2007

This may help you...

Using Sequential Document Serial Numbers
Reply With Quote


Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Forum Jump