Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: How can I make my Excel 2000 invoice template work?

25 Dec 2009   #1

Windows 7 X64 Home Premium
 
 
How can I make my Excel 2000 invoice template work?

I have put some serious hours into to trying to make this invoice template work with Windows 7. It came originally with Office 97 and Office 2000 and was designed by Village Software for Excel usage. What is nice about it is that it has a visual basic database attached to it to track fields of data on the invoice. I have tried everything to make this darn thing work and I really need it for my business. The file names that I copied over to Windows 7 are:

INVDB.XLS
TMPLTNUM.XLS
WZTEMPLT.XLS

I pasted these files into location C:/Program Files (x86)/Microsoft Office/Office12/Library as many on the net have suggested in XP (except it would be Office11). I have successfully performed this feat in XP but not Windows 7. Keep in mind that I did change the file location of INVDB.XLS in the template but everytime I try to save the file it says "cannot locate INVDB.XLS". I also do not get the number toolbar to sequentially increase the invoice number.

Has anyone successfully made this awesome template work on their Windows 7?

My System SpecsSystem Spec
.

27 Dec 2009   #2

Windows 7 X64 Home Premium
 
 

Wow...have I stumped the gurus out there? Amazing. If you need the template to play with or analyze go to

http://www.taclatch.com/taclatch.xlt
My System SpecsSystem Spec
03 Jan 2010   #3

W7 X-64 W8.1 X-64 Opensuse 13.1 W2003 Server
 
 

Hi all
It works fine in Office 2010 (at least from what I can see).

You have to 1) open in compatability mode
2) enable macros
3) disable some "protected content".

Office 2010 will "Convert" the template without a problem

enc image


I had to use an ACCESS 2010 DB as I don't have a Visual Basic DB - incidentally did you ever consider converting the EXCEL sheet to ACCESS and run your invoicing program from ACCESS DB (ACCESS 2010 is included in Office 2010).

Works fine -- use import facilty within ACCESS.

BTW the advantage in using a DB for invoices rather than spreadsheets is you can run a whole series of reports on it and it makes calculations for TAX etc really simple -- and of course submitting tax docs to relevanmt authorities.

Things like Addresses can be linked to customer number etc so inputting data / creating invoices would be so much quicker as well.

You can also run reports against services delivered to customers, outstanding amunts etc etc.

I'd use your template as a basis and convert to a DB system.

Cheers
jimbo


Attached Thumbnails
How can I make my Excel 2000 invoice template work?-invoice.png  
My System SpecsSystem Spec
.


04 Jan 2010   #4

Windows 7 X64 Home Premium
 
 

Hello Jimbo,

I am so jealous! So did you actually try to save the template as a worksheet in Excel and not get any warning? I can open up the invoice too but saving it is another story. Also, I have done everything in your list of requirements except disabling some "protected content". Elaborate on this one. That could be my problem. Your signature file says you are running XP. How about Windows 7? That could also be the issue for me.
My System SpecsSystem Spec
04 Jan 2010   #5

W7 X-64 W8.1 X-64 Opensuse 13.1 W2003 Server
 
 

Hi there
I was running Ms Office 2010 Beta with Windows 7 X-64 Enterprise. Download and install the trial -- but it should work on Office 2007 as well.

Must update the sig if it still says XP.

BTW it also works on other Windows 7 versions.

Download your own file -- change the name from .XLT to .xls and then try again.

Cheers
jimbo
My System SpecsSystem Spec
04 Jan 2010   #6

Windows 7 X64 Home Premium
 
 

Jimbo,

Do me a favor and send me your working invoice template and invdb.xls file. Tell me where you located each file in Windows 7 and I will try it out. Send files to jberenyi AT yahoo DOT com
My System SpecsSystem Spec
05 Jan 2010   #7

Windows 7 X64 Home Premium
 
 

Still waiting for your help Jimbo. Could really use it.
My System SpecsSystem Spec
06 Jan 2010   #8

Windows 7 X64 Home Premium
 
 

I still could use some help on this one Jimbo or anyone else.
My System SpecsSystem Spec
07 Jan 2010   #9

Windows 7 X64 Home Premium
 
 

HELP!
My System SpecsSystem Spec
08 Jan 2010   #10

W7 X-64 W8.1 X-64 Opensuse 13.1 W2003 Server
 
 

Hi there
I'll have another go later -- I'm doing a few things at the moment however -- and sitting waiting for Non Existant flights at Manchester Airport UK is not much Fun -- even the Beer at the bar is running low -- now that is bad -- delayed flights I can live with -- but NO BEER deliveries -- that's just CRIMINAL.

Cheers
jimbo
My System SpecsSystem Spec
Reply

 How can I make my Excel 2000 invoice template work?




Thread Tools



Similar help and support threads for2: How can I make my Excel 2000 invoice template work?
Thread Forum
Excel 2010 Template Issue Microsoft Office
Excel 2000 problem in Win7 BSOD Help and Support
Word 2000 Merriam-Webster Macro doesn't work Microsoft Office
Excel 2010 will not allow template to save due to not administrator Microsoft Office
Easier Way? Current:Exporting Data to Excel, General Template. Microsoft Office
microsoft excel "Trial period has expired, request new template" Microsoft Office
Excel 2000 display issues Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 01:39 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33