Hi there,
How can I specify which excel version start during com-handle creation
I'm automating Excel report and due to requirements both Excel 2003 and Excel 2010 should be installed.
In spite Excel 2010 is set as default :
DEFINE VARIABLE chExcel AS COM-HANDLE NO-UNDO.
CREATE "excel.application" chExcel.
chExcel:Workbooks:Open("c:\test1.xls").
this code opens Excel 2003 and also reset default to Excel 2003.
I've tried to check registry keys: HKCR\Wow6432Node\CLSID\ , I have tried to reregister Excel 2010, I have tried reinstall Excel 2010 over 2003. No luck.
Any thoughts will be highly appreciated.
How can I specify which excel version start during com-handle creation
I'm automating Excel report and due to requirements both Excel 2003 and Excel 2010 should be installed.
In spite Excel 2010 is set as default :
DEFINE VARIABLE chExcel AS COM-HANDLE NO-UNDO.
CREATE "excel.application" chExcel.
chExcel:Workbooks:Open("c:\test1.xls").
this code opens Excel 2003 and also reset default to Excel 2003.
I've tried to check registry keys: HKCR\Wow6432Node\CLSID\ , I have tried to reregister Excel 2010, I have tried reinstall Excel 2010 over 2003. No luck.
Any thoughts will be highly appreciated.