I am using VB6 and Excel 97.

I have a problem where if the is an instance of Excel is open with an
open workbook. And I try to do OLE Automation, then the data from one
report, ends up on the spreadsheet that happened to be open at the
time.

What can I do so that when I dump data into a spreadsheet, it will not
disturb other instances of Excel.