I have an Access DB which I use to create quotes (using an XL spreadsheet).

Works a treat - creates a new spreadsheet (based on a template) and a unique
reference number (which is exactly what I need).

What I need to do next is log the total figure back in my DB. Am not sure
what the best way to do this is - I have been looking at the BeforeSave event
of a workbook though not sure exactly how this works.