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. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto Assigning Number to Excel Invoice
I have been using a template created in Excel 2000 for my business invoices
for 7 years. This template had a tool box which allowed me to assign a sequential new number for each invoice automatically by clicking assign new number. Is this feature available in Excel 2007? I have tried enabling macros which were used on the previous version, but each time I attempt to run them, I get the message "The numbering add-in must be loaded for optimal numbering and toolbar behavior. Please load this add-in into your Library Directory." Where do I find this add-in? It is not located in Excel 2007 and I cannot find it on available downloads on Microsoft web-site... which is where I am directed from the help menu. PLEASE HELP!! |
#2
|
|||
|
|||
Auto Assigning Number to Excel Invoice
Just create a new macro to do that for you?
You can simply use te existing number, and add 1 to it, or you can store the number in the registry. I find that using the existing number is effective, and easy. Create a variable, sy vNumber as variant. Say your number is located in C5. Write the folowing macro Sub Number() vNumber = Range("C5").value vNumber = vNumber + 1 Range("C5").value = vNumber End Sub Create a button, and assign the macro to it -- HTH Kassie Replace xxx with hotmail "Angela Rose" wrote: I have been using a template created in Excel 2000 for my business invoices for 7 years. This template had a tool box which allowed me to assign a sequential new number for each invoice automatically by clicking assign new number. Is this feature available in Excel 2007? I have tried enabling macros which were used on the previous version, but each time I attempt to run them, I get the message "The numbering add-in must be loaded for optimal numbering and toolbar behavior. Please load this add-in into your Library Directory." Where do I find this add-in? It is not located in Excel 2007 and I cannot find it on available downloads on Microsoft web-site... which is where I am directed from the help menu. PLEASE HELP!! |
#3
|
|||
|
|||
Auto Assigning Number to Excel Invoice
I suspect that the add-in was part of the original template download.
Templates are often uploaded by users rather than being made by Microsoft, so it could have been a file that the original author built. Have you tried checking in the list of Add-Ins to see what information is there? Office Button - [Excel Options] and then click the Add-Ins link in the left pane. You could do a search on your system for *.xla files and see if the original add in is laying around. Then I'd try turning it into a .xlam file and installing that as part of your invoice template. "Angela Rose" wrote: I have been using a template created in Excel 2000 for my business invoices for 7 years. This template had a tool box which allowed me to assign a sequential new number for each invoice automatically by clicking assign new number. Is this feature available in Excel 2007? I have tried enabling macros which were used on the previous version, but each time I attempt to run them, I get the message "The numbering add-in must be loaded for optimal numbering and toolbar behavior. Please load this add-in into your Library Directory." Where do I find this add-in? It is not located in Excel 2007 and I cannot find it on available downloads on Microsoft web-site... which is where I am directed from the help menu. PLEASE HELP!! |
#4
|
|||
|
|||
Auto Assigning Number to Excel Invoice
I don't have xl2007, but this should work...
Do a file search for "TMPLTNUM.XLA". Then load it as an add-in. -- Jim Cone Portland, Oregon USA "Angela Rose" Angela wrote in message I have been using a template created in Excel 2000 for my business invoices for 7 years. This template had a tool box which allowed me to assign a sequential new number for each invoice automatically by clicking assign new number. Is this feature available in Excel 2007? I have tried enabling macros which were used on the previous version, but each time I attempt to run them, I get the message "The numbering add-in must be loaded for optimal numbering and toolbar behavior. Please load this add-in into your Library Directory." Where do I find this add-in? It is not located in Excel 2007 and I cannot find it on available downloads on Microsoft web-site... which is where I am directed from the help menu. PLEASE HELP!! |
#5
|
|||
|
|||
Auto Assigning Number to Excel Invoice
This link shows you two ways of maintaining these sequential numbers
for invoices etc.: http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Hope this helps. Pete On Jun 10, 9:09*am, Angela Rose Angela wrote: I have been using a template created in Excel 2000 for my business invoices for 7 years. *This template had a tool box which allowed me to assign a sequential new number for each invoice automatically by clicking assign new number. *Is this feature available in Excel 2007? *I have tried enabling macros which were used on the previous version, but each time I attempt to run them, I get the message "The numbering add-in must be loaded for optimal numbering and toolbar behavior. *Please load this add-in into your Library Directory." *Where do I find this add-in? It is not located in Excel 2007 and I cannot find it on available downloads on Microsoft web-site... which is where I am directed from the help menu. * PLEASE HELP!! |
#6
|
|||
|
|||
Auto Assigning Number to Excel Invoice
Works fine with Excel 2007 on Windows XP but if using Vista there are
Registry problems with the hard-coded Registry key in TMPLTNUM.XLA User would have to unprotect the add-in code and make changes to Registry storage key. I do have an unprotected copy of TMPLTNUM.XLA but not running Vista so cannot advise of code changes needed to write to Vista Registry. Copy available to OP if I get an email at gorddibbATshawDOTca I would suggest it may be easier to use JE's code and write to a text file if running Vista. Gord Dibben MS Excel MVP On Wed, 10 Jun 2009 05:52:37 -0700, "Jim Cone" wrote: I don't have xl2007, but this should work... Do a file search for "TMPLTNUM.XLA". Then load it as an add-in. |
Thread Tools | |
Display Modes | |
|
|