+ Reply to Thread
Results 1 to 2 of 2

SEQ reset with VBA

  1. #1
    Registered User
    Join Date
    02-18-2004
    MS-Off Ver
    2013 and 365
    Posts
    20

    SEQ reset with VBA

    Hi,
    I've googled and played but can't find an answer, is it possible to save the last value of a SEQ field and store it in Doc Properties and on next opening reset the \r switch of first SEQ to that value creating an auto updating serial number?

    regards
    John

  2. #2
    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: SEQ reset with VBA

    If the value is stored in a document property, you don't need to retrieve it from the SEQ field; simply retrieve it from the document property and update that. The SEQ field could then be coded with an embedded DOCPROPERTY field, as:
    {SEQ Nr \r {DOCPROPERTY Val}}
    where 'Val' is the document property's name.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Used Range Won't Reset At All
    By florismk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-10-2017, 06:35 AM
  2. [SOLVED] I need to create a reset button that will reset rows containing a specific value
    By odin78 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-03-2016, 02:11 PM
  3. Reset Spreadsheet Help
    By Cas39 in forum Excel General
    Replies: 5
    Last Post: 08-10-2013, 07:28 AM
  4. [SOLVED] reset cells to 0 all at once
    By Workshops in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-19-2006, 08:45 PM
  5. [SOLVED] Is there a reset shortcut
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2006, 03:40 PM
  6. reset to zero
    By baldyheed in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-01-2005, 11:05 PM
  7. reset me
    By cacique in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2005, 10:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1