Copying a sheet from another Excel instance?

G

Gustaf

Hi all,

In my app, I got a custom toolbar. One tool imports data exported to an Excel workbook from another app. The problem is that the exported workbook is not in the same Excel instance, so the custom toolbar isn't there. And as far as I understand, the Excel object model handles only one Excel instance, so there's no way for me to get to another instance using the Workbooks collection and so on.

Ideally, I'd like to open a form in my app, list all the open workbooks (regardless of Excel instance), and be able to pick the one I want. Is that possible?

Gustaf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Get Workbook path but from another excel instance 4
Open a New Instance of Excel 3
Copying worksheet from hidden instance of Excel 1
How to reference a file in a different instance of Excel? 4
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Custom Form 3
Multiple Workbooks Using the Same Custom Toolbar 2

Top