Need help with MS Word Automation
I am having problems finding information on using Word Automation.What I am trying to do is use CFMX (6.0) to open a MS Word template (.dot file), find the bookmarks in the file, insert data from our database at the bookmark locations, and then save the document as a new file on the server. Once the file has been saved, I need to push it to the client browser (via a UNC path). I think I have the information I need to work with the bookmarks, and know how to push the resulting file to the client.But I'm having problems reliably opening the word.application object. I'm sure this has been done before but am finding very little references in how to do it.Am I just misreading what I have found?Is there some trick that I don't know about? Thanks for any tips. Shawn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Need help with MS Word Automation
You are opening a can of worms...I don't recommend this.. But try www.cfcomet.com http://www.cfcomet.com/ And use OWA or whatever it is called. It is for Office and makes '00 and '03 automation much easier. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Shawn Grover [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 1:06 PM To: CF-Talk Subject: Need help with MS Word Automation I am having problems finding information on using Word Automation.What I am trying to do is use CFMX (6.0) to open a MS Word template (.dot file), find the bookmarks in the file, insert data from our database at the bookmark locations, and then save the document as a new file on the server. Once the file has been saved, I need to push it to the client browser (via a UNC path). I think I have the information I need to work with the bookmarks, and know how to push the resulting file to the client.But I'm having problems reliably opening the word.application object. I'm sure this has been done before but am finding very little references in how to do it.Am I just misreading what I have found?Is there some trick that I don't know about? Thanks for any tips. Shawn _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Need help with MS Word Automation
If you're open to options other than automation, take a look at these links: Integrating ColdFusion with Microsoft Office: Breezo and examples http://www.rewindlife.com/archives/000118.cfm Serving Word http://www.rewindlife.com/archives/32.cfm HTH, Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 1:06 PM To: CF-Talk Subject: Need help with MS Word Automation I am having problems finding information on using Word Automation.What I am trying to do is use CFMX (6.0) to open a MS Word template (.dot file), find the bookmarks in the file, insert data from our database at the bookmark locations, and then save the document as a new file on the server. Once the file has been saved, I need to push it to the client browser (via a UNC path). I think I have the information I need to work with the bookmarks, and know how to push the resulting file to the client.But I'm having problems reliably opening the word.application object. I'm sure this has been done before but am finding very little references in how to do it.Am I just misreading what I have found?Is there some trick that I don't know about? Thanks for any tips. Shawn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Need help with MS Word Automation
Hi Shawn, I have had a .doc generator running under CF5.0 Word 2000 for more than 1.5 years without a crash. Before settling on a server-side solution, I messed with .dot files on the client side but the potential mess was frightening (getting users to load and manage macros, etc.) The volume has been very low -- 2 or 3 15-page proposals per day the processing time takes about a minute (w/ nearly 100% cpu utilization). But nonetheless, we successfully pulled this off. I will add that it did take me weeks to get it right -- primarily due to the some pretty tight formatting requirements, self-doubt, etc. It's true that if your script bombs you will end up with multiple copies of winword.exe active. If I recall correctly, you may need to stop the Cold Fusion Application service to release some kind of lock then kill the multiple instances of winword. I relied heavily on http://www.cfcomet.com (gratefully, they are back online thanks to Mike Dinowitz). Contact me directly and I can provide some samples if you decide to build .doc files on the server from scratch. Best of luck, Mike Shawn Grover [EMAIL PROTECTED] 01/09/2004 01:06 PM Please respond to cf-talk To:CF-Talk [EMAIL PROTECTED] cc: Subject:Need help with MS Word Automation I am having problems finding information on using Word Automation.What I am trying to do is use CFMX (6.0) to open a MS Word template (.dot file), find the bookmarks in the file, insert data from our database at the bookmark locations, and then save the document as a new file on the server. Once the file has been saved, I need to push it to the client browser (via a UNC path). I think I have the information I need to work with the bookmarks, and know how to push the resulting file to the client.But I'm having problems reliably opening the word.application object. I'm sure this has been done before but am finding very little references i how to do it.Am I just misreading what I have found?Is there some trick that I don't know about? Thanks for any tips. Shawn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Need help with MS Word Automation
Thanks Sam.Your presentation helped clarify a number of points for me. Basically the automation capabilities suck (as far as server side access goes).But I think I have found a solution by saving the template as HTML then tweaking the output as needed, and pushing it to the client as a word document.I never thought that Word's ugly XML might actually come in handy one day... grins/ Thanks again. Shawn -Original Message- From: Samuel R. Neff [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:29 AM To: CF-Talk Subject: RE: Need help with MS Word Automation If you're open to options other than automation, take a look at these links: Integrating ColdFusion with Microsoft Office: Breezo and examples http://www.rewindlife.com/archives/000118.cfm http://www.rewindlife.com/archives/000118.cfm Serving Word http://www.rewindlife.com/archives/32.cfm http://www.rewindlife.com/archives/32.cfm HTH, Sam --- Blog: http://www.rewindlife.com http://www.rewindlife.com Charts: http://www.blinex.com/products/charting http://www.blinex.com/products/charting --- -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 1:06 PM To: CF-Talk Subject: Need help with MS Word Automation I am having problems finding information on using Word Automation.What I am trying to do is use CFMX (6.0) to open a MS Word template (.dot file), find the bookmarks in the file, insert data from our database at the bookmark locations, and then save the document as a new file on the server. Once the file has been saved, I need to push it to the client browser (via a UNC path). I think I have the information I need to work with the bookmarks, and know how to push the resulting file to the client.But I'm having problems reliably opening the word.application object. I'm sure this has been done before but am finding very little references in how to do it.Am I just misreading what I have found?Is there some trick that I don't know about? Thanks for any tips. Shawn _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
