Tpaul_10
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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)