MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel sheet in word?? Macro?

Posted by mike on December 28, 2000 8:55 AM

i have an invoice. i want it to have a number on each one, and have that number update when i write up each invoice.. how do i do that using a macro??


Posted by Robert on December 28, 2000 2:40 PM

The way to set that up is probably better in Excell as the computations etc are defined easier in a sheet than in word.

Make an invoice template and store the template in the template directory.
By using file new you can select the invoice. There are several ways to remember the last issued invoice number. You could write it in the registry or keep it in a text file. When you create the invoice you could get the number on open or make a button which reads and updates the invoice number. It will take a bit of work. Where does the data for the invoice come from? It would be nice to integrate the data, so no retyping needs to take place. If you keep the data in Access, together with your customer data and product info, it would be a neater solution.