Link to home
Start Free TrialLog in
Avatar of Tpaul_10
Tpaul_10Flag for United States of America

asked on

CFOBJECT errors

1.      Recently I have installed (not upgraded) MS Excel 2007 on my machine and still have the old versions.
2.      My upload functionality using excel 2007 to SQL is working fine.
3.      But I have old upload application or code which uses Prior versions of excel and the old code is not working after I have installed 2007 excel.
4.      I am getting the following errors.
a) An exception occurred when accessing a Com object field and here is the code

<cfobject action="CONNECT" class="Excel.Application" name="objExcel" type="COM">      

b) The selected method Quit was not found.
<CFSCRIPT>
objExcel.Quit();
objExcel = "nothing";
</CFSCRIPT>

5.      Is there anything do with the installing 2007 excel

Any help or inputs will be appreciated.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of SidFishes
SidFishes
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
which means a reinstall of the version you need to run with cfobject -should- fix your problem (although I wouldn't put money on it - multiple versions, especially from 2007+ have cause me a lot of grief. (in access though not excel)