I am using Excel 97. I made a popular workbook a template so that it will save certain contents to Access. On 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.
PS. I hope that I expalined it ok.