Forum Discussion
AlexKaras
Champion Level 3
Hi,
Not sure, but considering that Outlook is a part of Office, this might appear to be of some help: https://smartbear-cc.force.com/portal/KbArticleViewer?name=Get-COM-reference-for-a-running-Excel-instance&sp=testcomplete
krishnapuli
7 years agoOccasional Contributor
Hi,
I have red the provided article and came to know that getobject function does not bind to the existing excel application.
I don't know the exact internals of how COM works but Getobject can get the existing excel reference.
Following steps works in VB script.
Set Obj=CreateObject("Excel.Application") will give new excel instance.
Set Obj=GetObject(,"Excel.Application") will give existing excel instance.I.e Open excel application and run this statement.This statement binds to the opened excel application.
Related Content
- 2 years ago
Recent Discussions
- 16 hours ago
- 2 days ago