I have been facing big difficulties in using COM Objects to access Excel, (Platform Win2000, Office2000, CFMX). When the same code was on CF5.0 it worked perfectly without any problems.
In the beginning, COM Objects couldn't connect to Excel, after doing several installations of Office2000, it connected successfully. The main problem started happening afterwards, which is accessing the Excel COM Object properties (The main error occurs whenever it tries saving the file). In brief, below are the main steps of I did so far; 1- I followed all the instructions recommended in Macromedia's article (http://www.macromedia.com/v1/Handlers/index.cfm?ID=22922&Method=Full) Followed the steps, and still the same error, no joy. 2- I changed the permissions of ColdFusion in the services Applets as recommended in cfcomet.com (http://www.cfcomet.com/other/index.cfm?ArticleID=32381637-0922-41CA-BBE 305C2D66A7025#22) Restarted the services and the server and still the same error. 3- Downloaded and installed the Updater (http://dynamic.macromedia.com/bin/MM/software/trial/hwswrec.jsp?product =cfmx_updater) after showing installation was successful, I restarted the services and the whole server again. I kept getting the same error, except for one trial that was successful, afterwards it returned back to the same problem. Eric (Sael) Zumot, Senior Programmer, BizNet Solutions, 133-137 Lisburn Road, Belfast, Northern Ireland BT09 7AG T:++44 (028) 90223224 F:++44 (028) 90223223 E:[EMAIL PROTECTED] W:http://www.bizNet-solutions.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
