How embarrassing! After all that, I finally checked my data tables. None of the criteria that I set matched any records. Once I fixed my criteria, it did the addition OK. However, now my problem is calling the spreadsheet that I want. I get an OLE message that says Unknon name.
Code line: oxl.workbook.open("YearSummReport.xls")
I've already created this workbook, and it's in the current path. The line above this one calls Excel. So it must be a matter of determining how to open a specific worksheet. New thread?