invoice toolbar for invoice calcuation and assign number

[KarenY]

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

 

[Joel]

I think you lost your personal.xls file which did some initializattion before
excel was started.
Usually when a new version of office is installed they will change Offfice10
to office11

from
C:\Program Files\Microsoft Office\Office10
to:
C:\Program Files\Microsoft Office\Office11


Frist check which version(s) of office existts on your machine.
then search the directory C:\Program Files\Microsoft Office for the file
personal.xls. If it exists the copy it from the older version of office to
the new version of offfice.

 

[Dave Peterson]

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

http://www.microsoft.com/downloads/...D8-094D-4ED1-88DA-F4B8B2AD28BD&displaylang=en

or

http://snipurl.com/pm5l

 

[KarenY]

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

 

[KarenY]

I found it and copied it as what you said, it's not working either.

Actually I saved all my macros in this personal.xls
The Add-in "Invoice" tool box not there, when I open the Template, the
little tool-box not popping up. In other words, I couldn't work on the
Temp-plate because I couldn't find a way to assign a number for my shipping
invoice being assigned by the system and stored in the data-base.
What shall I do now? please help

 

[Dave Peterson]

Try this post from Gord Dibben:

http://groups.google.co.uk/group/mi...ztemplt+group:*excel*&rnum=4#eaaec8e8ba9c9c82

or
http://snipurl.com/1cvuq

 

[KarenY]

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]

What happened when you opened the .xls files and did File|SaveAs and chose excel
addin (*.xla).

I didn't have a problem doing that.

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

 

[KarenY]

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

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]

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]

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

 

[Dave Peterson]

There are a few people who are unavailable this week who have used the invoice
stuff. You'll find their names a lot in your google search.

If you don't find a solution, you may want to wait a couple of days and repost
your question. Include all the stuff you've tried.

Maybe one of them will read your message and give you the solution.

(I'm afraid that this thread is gonna get ignored when they're available again.)

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

 

[Gord Dibben]

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

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

 

[Dave Peterson]

Whew!

Thanks Gord.

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

 

[KarenY]

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]

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

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

 

[KarenY]

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