You could write a proxy com object, this is what I have done for create webdirs on the fly... Instead of CF having to instantiate multiple object then checking this that and everything, I have written a com object which says create this dir. Then the proxy object does all the complex stuff returning a true or false depending on the outcome...
HTH Mikey -----Original Message----- From: Cassidy Symons [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 17:53 To: CF-Talk Subject: Increase stability in Excel COM object? I've been trying to get solid, stable code for writing an XLS file using a COM object, but it seems to break every few times I try it, even with TRY/CATCH statements. I copied the basic code straight out of the Ben Forta books, then just made changes to the database stuff based upon my specific needs. Any ideas on how I can make it run on a regular basis without having to screw around? I'm on Windows 2000 Advanced Server and CF5. Cassidy NETPACQ Systems, Inc. "Full Service Web Media" 5205 Kearny Villa Way, Suite 106 San Diego, CA 92123-1410 Voice - 1-858-541-0222 Fax - 1-858-874-7771 [EMAIL PROTECTED] http://www.netpacq.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
