I am using Excel 97. I want to make a popular workbook a template and have set up so that it will save certain contents to Access. This workbook is how our company quotes jobs. We want to save this info so that we can do analysis later. In this workbook, I have a macro that will print it and then clear it. Bottom line is that I want to be able to save the info, print it then clear the contents.
I saw in the Excel help that you can create a template that copies worksheet data to a database. I set up the template and linked the fields in the worksheet to the Access database. I guess that I have to learn more about saving the information to an Access database.
At what point does the information get sent and saved?
Could I automate this task with a macro?
Then I could add it to the macro that print and resets the worksheet.
My problem is that we will do multiple quotes at a time (one after another) and I need to be able to send the data to the database when we are done with a quote, like when the quote is printed.
If the saving is done when it closes, then is there a way to send the data to the database with a macro?
PS. I hope that I expalined it ok.