>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.

That happens to all of us. I'm glad you figured it out. What we all need is a computer that knows how to do what we meant instead of what we wrote!

>However, now my problem is calling the spreadsheet that I want.
>I get an OLE message ... [should this be a] New thread?

Yes, it would probably be best to start a new thread since this is a new topic. There are several folks here who are expert in OLE automation, I'm sure you'll get more than one response.

And by the way, welcome to the UT!