+ Reply to Thread
Results 1 to 5 of 5

Thread: reference number generated on printing

  1. #1
    Registered User
    Join Date
    08-04-2010
    Location
    Rotherham
    MS-Off Ver
    Excel 2003
    Posts
    22

    reference number generated on printing

    Hi, I currently have a word form to fill in for when we carry out a product test on something. I would like each form that is printed off to be identifiable by a number at the top.

    Basically everytime I print this particular document off in word I want a new number generated on it. Is this possible?

  2. #2
    Registered User
    Join Date
    08-04-2010
    Location
    Rotherham
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: reference number generated on printing

    Still no answer?

    In effect I suppose it could be a page number (at the top of the document) However if I printed off 10 copies of the form one day (0001,0002,0003,0004 etc) then the next time I'd print off I'd want it to automatically start at 0011,0012,0013 etc. And then what happens when you hit all 4 digits (this can't go on infinitely or can it)

    I've seen this kind of thing on forms before, where each copy of a form has a different sequential number. Just haven't a clue what it's called or how to do it.
    Last edited by benjii19; 03-03-2011 at 08:28 AM.

  3. #3
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2003, Excel 2007 (Portable)
    Posts
    388

    Re: reference number generated on printing

    I have used some VBA to do auto counter on printing

    Create a textbox in the document and use the code in attach in the respective places.

    After setting it must save, closed and reopen it to load the module


    Regards
    Attached Files Attached Files
    Mahju

    Mark the thread as solved if you are satisfied with the answer

    Rule 9
    Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  4. #4
    Registered User
    Join Date
    08-04-2010
    Location
    Rotherham
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: reference number generated on printing

    Thank you,

    Could the code work so that say I print 100 copies off, instead of printing 100 of the same number it goes up one verytime printed?

    Does this code remember the last session you printed?

    I've only had a quick look but will try out more later.

  5. #5
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2003, Excel 2007 (Portable)
    Posts
    388

    Re: reference number generated on printing

    It will add one on each print command.

    one copy should be printed at a time
    i.e File menu + print
    In Number of copies text box there should be 1 otherwise same number will be printed.

    It will remember the previous session as It will save the file after each print.
    Use textbox property sheet to set the number to start


    Thanks


    Regards
    Mahju

    Mark the thread as solved if you are satisfied with the answer

    Rule 9
    Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0