Record Printed Excel sheet data
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.
Re: Record Printed Excel sheet data
you can use the workbook before print event to fire the code