I am trying to open an excel workbook while Excel is open, using SCL code. I
know how to open a new excel session and then open a workbook with the following
hostcl = loadclass('sashelp.fsp.hauto');
call send (hostcl,'_new_',excelobj,0,'excel.application.5');
call send (excelobj,'_set_property_','visible','true');
call send (excelobj,'_get_property_','workbooks',tst) ;
call send(tst,'_do_','open','H:\my documents\projects.xls' );
Is there a way to open the worrkbook in an existing Excel session? I am stumped
on how to get the object id of the existing Excel session using SCL.
Any help would be much appreciated.