Record Printed Excel sheet data

[khumbulau]

Good day.

Specs:
I have got a template for printing invoices in excel. Whenever I print the invoices I use this template which has fields invoice date, amount and the name of the person receiving the invoice.

what I would like to do is whenever I print an invoice a vb code should be run in the background. The code should collect the three above mentioned fields and add them as a new record in a table found in the invoices database. The invoices database will have a table named invoices. The invoices table will have the three mentioned fields plus another field that will have a number of the record being added.

this is so that I should be able to easily keep track of the invoices I have printed without wasting too much space storing each invoice as a workbook.

[westconn1]

you can use the workbook before print event to fire the code