Auto Assigning Number to Excel Invoice


A

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

Advertisements

K

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
 
J

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.
 
J

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

Advertisements

G

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top