Attach to MS Excel turned on from different app

[RobertRajczyk1]

Hello,

I am struggling with correctly attaching to Excel instance that is already running (there is no option for downloading it and opening later). 

When I am using the default Excel VBO action - 'attach' it is connecting to empty workbook. 

I solved it initially with first killing all running Excel processes that WindowName differ from the one I want to connect and later attaching to it. Actually it's still working fine in the debug mode. 

However when I am trying to run the process from the Control Room I am getting all the time the error "Cannot create activex component" (actually it's 'ActiveX-Komponente kann nicht erstellt werden' in German).  

Can you please support me with this? Maybe there is some way of connecting to Excel based for example on a process ID? 

[ewilson]

Hello @RobertRajczyk1,

Are you testing debug and Control Room on the same machine? An ActiveX error like that usually indicates that the required Microsoft Office libraries are not properly registered on the machine.

You're using the Attach to Workbook action, correct? If you're using the regular Attach action, it connects to the first instance of Excel it finds in the process list. 

Cheers,
Eric