+ Reply to Thread
Results 1 to 9 of 9

Numbering add-in not working?

Hybrid View

  1. #1
    Registered User
    Join Date
    03-31-2015
    Location
    Detroit, MI
    MS-Off Ver
    2003
    Posts
    3

    Question Numbering add-in not working?

    Hey Gang:

    Please excuse the newbie question.

    I have just re-installed (on a new Windows 7 Pro 64 OS) Office 2003 (yeah, I know...) of which Excel 2003 is a major component of my business operations. Since the installation, I have been unsuccessful in getting the numbering add-in/macro to advance the Invoice Number field in my Invoice template files. It WILL replace the field contents with the numeral 1, but subsequent invoices ALSO will be input with the numeral 1 (NOT incrementing).

    Any ideas as to where I should start troubleshooting this?

    Thanks!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,100

    Re: Numbering add-in not working?

    You want to share the code? And maybe the add-in?

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-31-2015
    Location
    Detroit, MI
    MS-Off Ver
    2003
    Posts
    3

    Re: Numbering add-in not working?

    I'm afraid that I don't know anything about the "code", but the add-in is "Tmpltnum.xla". Not sure how to share that file here, as there doesn't seem to be a way of attaching files to a post.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,100

    Re: Numbering add-in not working?

    Sure there is.

    To attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Numbering add-in not working?

    Cheers
    Andy
    www.andypope.info

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,100

    Re: Numbering add-in not working?

    Ahhhh ... to quote from the link that Andy has provided:

    These following add-ins are no longer included with Excel 2002 and with later versions of Excel. Additionally, they are not available for download:

    Autosave Add-in (Autosave.xla)
    MS Query 1.0/2.0 Compatibility (Xlquery.xla)
    Template Utilities (Tmpltnum.xla)
    Update Add-in Links (Updtlink.xla)

    Note Downloadable add-ins are available for Excel 2002 only. These add-ins are not supported for installation in Excel 2003 or in Excel 2007.

    To use the older add-ins with Excel 2007, you must install the VBA Converter Pack for Microsoft Office Excel 2007.

    For more information about the VBA Converter Pack, click the following article number to view the article in the Microsoft Knowledge Base:
    926430 Error message when you try to open an Excel 5.0/95 workbook that contains a VBA module sheet in Excel 2007:
    "Opening the VBA project in this file requires a component that is not currently installed"

  7. #7
    Registered User
    Join Date
    03-31-2015
    Location
    Detroit, MI
    MS-Off Ver
    2003
    Posts
    3

    Re: Numbering add-in not working?

    Well, this feature WAS working on my previous computer running WinXP Pro 32 bit under Office 2003...

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,100

    Re: Numbering add-in not working?

    I am but the messenger

  9. #9
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Numbering add-in not working?

    You must have had an old version of excel prior to you 2003 upgrade. In which case you need to install all the required files from that previous install
    http://www.tek-tips.com/viewthread.cfm?qid=1446546

+ 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. Replies: 2
    Last Post: 06-27-2014, 06:40 AM
  2. Replies: 4
    Last Post: 09-03-2013, 02:52 AM
  3. Replies: 2
    Last Post: 08-17-2012, 08:16 AM
  4. weird (auto numbering) numbering ....
    By freestone in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2010, 07:46 PM
  5. WBS numbering help, auto numbering with indenture
    By hisham2929 in forum Excel General
    Replies: 2
    Last Post: 02-18-2007, 06:59 PM

Tags for this Thread

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