Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto populating and assigning numeric value to a number | Excel Worksheet Functions | |||
Assigning invoice numbers automatically in excel? | Excel Worksheet Functions | |||
Auto Number in Invoice | New Users to Excel | |||
Invoice number that auto advances??? | New Users to Excel | |||
auto insert invoice number that increases by one each time opened | Excel Worksheet Functions |