Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding an active OLE-Application...

Status
Not open for further replies.

FanTasteYou

Programmer
Oct 26, 2000
3
DE
Hello, i have two running Instances from Excel. One with an AddIn, the other without any AddIn. Now, i use GetActiveObject('Excel.Application') to get the IDispatch-Interface from Excel, but i can't exactly specify, which Instance i get at least. The CLSID of both Excel-Application in the ROT are the same, so that i can't select the correct Instance in the ROT. In the ROT, I find the IDispatch-Interface from the wanted Excel AddIn (.XLA), but i need the corresponded Appliaction-Object (i need the Method Application.Run).
Is it possible, to solve this problem ? - Who can help me ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top