Auto Assigning Number to Excel Invoice

[Angela Rose]

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!!

 

[Kassie]

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

 

[JLatham]

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.

 

[Jim Cone]

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 (e-mail address removed)>
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!!

 

[Pete_UK]

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

 

[Gord Dibben]

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