The problem is that Office is not reentrant, and isn't intended to be run in a server-based environment. Office will probably break under any decent load.
Microsoft has a few articles to help out, but don't expect miracles. Configure Office Applications for Automation from a COM+/MTS Package: http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b288368 Considerations for Server-Side Automation of Office: http://support.microsoft.com/default.aspx?scid=kb;EN-US;257757 Kevin -----Original Message----- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 10:02 AM To: CF-Talk Subject: RE: Increase stability in Excel COM object? 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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4