....oh ...sorry ...I forgot to mention ...this is on CF5 ..and for varied
and sundried reasons, we can't upgrade versions of CF, so I don't have
releaseComObject available to me, but looking at the CF 7 docs, that
would TOTALLY do what I need it to :(

-----Original Message-----
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: Monday, September 12, 2005 2:01 PM
To: CF-Talk
Subject: RE: MS Word Com problem with CF


Try this:

[cfset releaseComObject(objectName)]

M!ke

-----Original Message-----
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 
Sent: Monday, September 12, 2005 2:51 PM
To: CF-Talk
Subject: MS Word Com problem with CF

I am having to convert an asp program to CF and one of the functions
needed is a server based mailmerge. I have it working in CF, except it
creates a Word app on the server EVERYTIME the template is invoked, I'm
invoking as:

<CFTRY>
   <CFOBJECT 
       ACTION="CONNECT" 
       CLASS="Word.Application" 
       NAME="WordApp" 
       TYPE="COM">
   <CFCATCH>
    <CFTRY>
        <CFOBJECT 
            ACTION="CREATE" 
            CLASS="Word.Application" 
            NAME="WordApp" 
            TYPE="COM"> 
      <CFCATCH TYPE="Object">
          <FONT COLOR="RED">Error creating word object.</FONT>
          <CFABORT>
      </CFCATCH>
    </CFTRY>
  </CFCATCH>
</CFTRY>

then at the end:

<cfset  x = ActiveDocument.Close()>
<cfset  x = WordApp.Quit()>

The task manager on the server shows that word, after word, after word
is beeing created but not "destroyed" ...as a point of reference in the
asp app the object is created as:


  Set WordApp = CreateObject("Word.Application")


and I KNOW for a fact the line that "smokes it" out of the task manager
is:

  set wordapp=nothing



.........any help would be GREATLY appreciated!!



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217989
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to