Prattaratt
Technical User
I know this is a long-standing issue, but I have already tried all the fixes I have run across.
1. I need to transfer some data from a IE Addon that I wrote to an Excel Spreadsheet of my own design. I can create an new instance and control ; My problem is trying to connect to an already running instance through COM. I am working on RadStudio XE2 on a Win7 64bit machine.
2. I have already tried using GetActiveObject('Excel.Application'); . This results in an eOLESysError Exception, 'Operation unavailable". I have tried to send a WM_ACTIVATEAPP message to the already running instance's main window in an effort to get the existing instance to register on the RunningObjectTable; same result. I have tried using a TExcelApplication with it's ConnectKind property set to ckRunningInstance; again 'Operation Unavailable.'
3. I want to try a manual registration of the instance on the ROT, either from my addon or from within the Excel app itself but need some examples to work from. If there is anybody out there that would be willing to advise or has a working example of how to make this connection work, I would be much obliged. My Google searches are running dry.
1. I need to transfer some data from a IE Addon that I wrote to an Excel Spreadsheet of my own design. I can create an new instance and control ; My problem is trying to connect to an already running instance through COM. I am working on RadStudio XE2 on a Win7 64bit machine.
2. I have already tried using GetActiveObject('Excel.Application'); . This results in an eOLESysError Exception, 'Operation unavailable". I have tried to send a WM_ACTIVATEAPP message to the already running instance's main window in an effort to get the existing instance to register on the RunningObjectTable; same result. I have tried using a TExcelApplication with it's ConnectKind property set to ckRunningInstance; again 'Operation Unavailable.'
3. I want to try a manual registration of the instance on the ROT, either from my addon or from within the Excel app itself but need some examples to work from. If there is anybody out there that would be willing to advise or has a working example of how to make this connection work, I would be much obliged. My Google searches are running dry.