I have an addin ("Invoicing: Simple Bookkeeping") that I've developed
for use by self-employed people or small home-based business ventures.
It doesn't use any MS invoice templates but it does provide 4 templates
by default, customizeable to the user's specs. These are generated to a
fiscal workbook and currently need to be entered manually in the
associated "bookkeeping" workbook for the fiscal period. (Fiscal period
is Jan 1 to Dec 31; normal individual tax year) Since the bookkeeping
file is separate (invoicing or beeokkeeping work stand-alone) it makes
sense to offer an option to programmatically add invoices to the
"Income" sheet of the bookkeeping file as they're created. Though users
can change the invoice template on the fly, sales transaction numbering
(format:="yyyy-####") is sequential regardless of which template is
used, so inserting the details into the Income sheet is trivial
(date,customer,invoice#,currency,amount,tax1,tax2) .

I'd be interested in studying the wizard addin if it writes to a
summary sheet. Otherwise, I intend to use ADODB if the bookkeeping file
is not open; write the sheet directly if the file is open.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc