+ Reply to Thread
Results 1 to 2 of 2

Automatically Increase Request No. by One Upon Printing

  1. 11-08-2013, 09:35 PM #1
    Cansa
    Cansa is offline
    Registered User
    Join Date
    09-20-2012
    Location
    La Crosse, WI
    MS-Off Ver
    Excel 2010
    Posts
    70

    Automatically Increase Request No. by One Upon Printing

    Hi All!

    I'm hoping that this Macro wont be too difficult to code, but I've been trying to create a macro that will increase the Request Number Sequentially by 1...Starting at "00001" Attached i have the document, and I've highlighted the area where i would need the Request Number shown...If the document can be saved after each time it is printed then when it is reopened and reprinted it can start where it left off at....

    I appreciate any help given!

    Cansa
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-08-2013, 09:57 PM #2
    macropod
    macropod is offline
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Automatically Increase Request No. by One Upon Printing

    See, for example: http://www.msofficeforums.com/word/7...html#post34444. The attachment increments a counter each time a new document is created from the template.
    Last edited by macropod; 11-08-2013 at 10:00 PM.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically Increase Request No. by One Upon Printing
    By Cansa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-09-2013, 12:25 AM
  2. Request password before printing
    By nbuk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2010, 12:04 PM
  3. Automatically increase value
    By Jazzy Max in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-21-2009, 06:13 PM
  4. increase number automatically
    By starlw116 in forum Excel General
    Replies: 1
    Last Post: 06-08-2006, 02:11 AM
  5. Hide individual/range cells and temporarily increase scale for printing
    By chris100 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2005, 03:54 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1