How can I make my Excel 2000 invoice template work?


  1. Posts : 47
    Windows 7 X64 Home Premium
       #1

    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 Computer


  2. Posts : 47
    Windows 7 X64 Home Premium
    Thread Starter
       #2

    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 Computer


  3. Posts : 5,941
    Linux CENTOS 7 / various Windows OS'es and servers
       #3

    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 Attached Thumbnails How can I make my Excel 2000 invoice template work?-invoice.png  
      My Computer


  4. Posts : 47
    Windows 7 X64 Home Premium
    Thread Starter
       #4

    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.
    Last edited by jberenyi; 04 Jan 2010 at 07:53.
      My Computer


  5. Posts : 5,941
    Linux CENTOS 7 / various Windows OS'es and servers
       #5

    Hi there
    I was running Ms Office 2010 Beta with W7 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 W7 versions.

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

    Cheers
    jimbo
      My Computer


  6. Posts : 47
    Windows 7 X64 Home Premium
    Thread Starter
       #6

    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
    Last edited by jberenyi; 04 Jan 2010 at 12:47.
      My Computer


  7. Posts : 47
    Windows 7 X64 Home Premium
    Thread Starter
       #7

    Still waiting for your help Jimbo. Could really use it.
      My Computer


  8. Posts : 47
    Windows 7 X64 Home Premium
    Thread Starter
       #8

    I still could use some help on this one Jimbo or anyone else.
      My Computer


  9. Posts : 47
    Windows 7 X64 Home Premium
    Thread Starter
       #9

    HELP!
      My Computer


  10. Posts : 5,941
    Linux CENTOS 7 / various Windows OS'es and servers
       #10

    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 Computer


 

  Related Discussions
Our Sites
Site Links
About 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 20:58.
Find Us