Hi, Gord
I have added the TMPLTNUM.XLA in add-in after reading in your website.
Apparently, I might have done it wrong. it still didn't work.
I will send the file again, the mail was rejected due to the wrong address,
sorry.
I hope you do receive it this time, I really really appreciate for this.
thanks
Karen

"Gord Dibben" wrote:

Karen

Not yet received.

My email address for the the purposes of this news group posting is

gorddibbATshawDOTca

Change the AT and DOT to punctuation.

Notes on the invoice template.

The Sales Invoice Template that comes packaged with Excel 2002 and 2003 is not
the same as the INVOICE.XLT packaged with earlier versions of Excel and does not
have the VBA code that the older version has.

You can use the earlier version and still retain the functionality if you have
the TMPLTNUM.XLA add-in.


Gord

On Thu, 15 Mar 2007 01:23:15 -0700, KarenY
wrote:

Fantastic! Gord. I am so happy to read your reply !!!
I am sorry I just read the mail today because of the time difference we have.
I hope I can figure what you meant about your Email address. I sent
already. I hope you receive it. Please let me know.

thanks
Karen

"Gord Dibben" wrote:

Karen

Do you still have the original INVOICE.XLT file that you used with Excel 2000 or
a workbook created with it?

I think I can help you get the Invoice Numbering Toolbar back but I will have to
do a bit of code-altering.

Change the AT and DOT in my email address to appropriate puctuation and send me
a file I can work on(preferably a copy of the original INVOICE.XLT Template) but
if not, one of the invoices you created.

At the very least I will get you a button that assigns a sequential number to
the invoice.

I will send the file back with a description of what I have done.


Gord Dibben MS Excel MVP



On Wed, 14 Mar 2007 01:00:00 -0700, KarenY
wrote:

thanks for the heads up, I will look for it on google.
Again, thanks for your patience.
best regards,
Karen

"Dave Peterson" wrote:

I've been searching google to find tips to help. Everything I've read sounds
like you can just copy the files into your addin folder.

I've never used this and I'm not sure what the popup box is.

Maybe you can find something on google????

KarenY wrote:

I don't know whether I need to install all those .xla file from "Library" in
the link you supplied.
I couldn't open Tmpltnum.xla and Wztemplt.xla and I could open Invdb.xls.
Instead of opening it, I changed the from .xls into .xla.

Now, I open my Template Invoice file (created in Excel 2000), there is no
pop up box for me to assign a number.
I had parked the above-mentioned 3 in the Office11 - Library , also tried in
the Add-ins.

What else I should do? Thanks, Dave.
Karen

"KarenY" wrote:

Hi Dave,
I followed the isntruction written in link of LOADING ADD-INS and downloaed
those .xla files.
Those .xla became .xls files - I couldn'd install to my Add-Ins.
I tried to see what's wrong in my downloading but couldn't see what I had
done wrong.
It doesn't allow me to save as .xla file at all.
why ? please help.
sorry for all these troubles....

"Dave Peterson" wrote:

Try this post from Gord Dibben:

http://groups.google.co.uk/group/mic...aec8e8ba9c9c82

or
http://snipurl.com/1cvuq


KarenY wrote:

I dowloaded and installed it, no "invoice" add-in either, i.e. the little
tool-box not poping up for me to assign a number??

"Dave Peterson" wrote:

I'm not sure if this works with xl2003, but you could try it:

http://www.microsoft.com/downloads/d...displaylang=en

or

http://snipurl.com/pm5l


KarenY wrote:

Our office has upgraded the Microsoft Office package from 2000 to 2003.
I had an Excel Invoice Template prior to the upgrade, when I used the
Template for creating a new invoice (new file), there was an Invoice Toolbar
popping up in order for me to assign a next serial number. However after the
upgrade, the invoice toolbar is not there when I open the Template ???
Please help where can I pull the Invoice Toolbar and add it on in my
computer ?

thanks
Karen

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson