Creating an instance of an open Excel application
Posted on 1998-09-13
I'm writing a small app that uses OLE to communicate with Excel. I know how to automate opening a new Excel application, adding a new workbook, and attaching an IDispatch pointer to Sheet #1. How do I initiate communication with Sheet1 of Book1 of an Excel application that is already open? Any sample code appreciated. Thanks.