Author | Topic: Using Word for notepad entry and for Mail Merge | |
---|---|---|
Phil Jackson | Using Word for notepad entry and for Mail Merge on Thu, 11 Dec 2008 09:55:33 +1300 Word already provides spell checking and I wonder if the following is possible with ActiveX and xBase 1) Pop up a screen to edit/enter some text using Word - keep controls to a minimum. Use native ability to spellcheck / grammar check. Ideally the size of the screen is under my control. 2) Send text to clipboard as required. 3) Or, swap data fields for producing mail merge letters - saved as files (DOC or HTML) I have never used ActiveX but wonder if someone can point me in the right direction to get started. I am not averse to paying for someone's time if that saves me a great deal more time - if someone is already doing the above then that would be very good! I'm currently using 602Text which probably doesn't handle ActiveX and would install Word to get this working as needed. Cheers Phil Jackson | |
AUGE_OHR | Re: Using Word for notepad entry and for Mail Merge on Wed, 10 Dec 2008 22:34:46 +0100 hi, for ActiveX you can use CreateObject(), GetObject() or XbpActiveXControl(). to have a ActiveX "under Control" you must use XbpActiveXControl() else you can not "react" on ActiveX (... yes you can :dynamicCast() ... ) i did not have seen any Sample with Word and XbpActiveXControl() yet. greetings by OHR Jimmy | |
Phil Jackson | Re: Using Word for notepad entry and for Mail Merge on Thu, 11 Dec 2008 11:05:18 +1300 Thanks Jimmy I'll hang out for someone who has some knowledge on this. If no one has done this before, can someone come back to me with a price for the development of this. I will then make it available to the Users Group. Cheers Phil Jackson AUGE_OHR wrote: > hi, > > for ActiveX you can use CreateObject(), GetObject() or XbpActiveXControl(). > > to have a ActiveX "under Control" you must use XbpActiveXControl() else > you can not "react" on ActiveX (... yes you can :dynamicCast() ... ) > > i did not have seen any Sample with Word and XbpActiveXControl() yet. > > greetings by OHR > Jimmy > > | |
Mark Sergent | Re: Using Word for notepad entry and for Mail Merge on Thu, 11 Dec 2008 09:51:22 -0800 On Thu, 11 Dec 2008 09:55:33 +1300, Phil Jackson wrote: > Word already provides spell checking and I wonder if the following is > possible with ActiveX and xBase > > 1) Pop up a screen to edit/enter some text using Word - keep controls to > a minimum. Use native ability to spellcheck / grammar check. Ideally the > size of the screen is under my control. > 2) Send text to clipboard as required. > 3) Or, swap data fields for producing mail merge letters - saved as > files (DOC or HTML) > > I have never used ActiveX but wonder if someone can point me in the > right direction to get started. I am not averse to paying for someone's > time if that saves me a great deal more time - if someone is already > doing the above then that would be very good! > > I'm currently using 602Text which probably doesn't handle ActiveX and > would install Word to get this working as needed. > > Cheers > > Phil Jackson Hi Phil, There is also an activex product called TXText Control that we are using in our new application. It is a full activex word processor that creates a number of file formats including office2003/2007 html pdf etc. It has full mailmerge capabilities and spell checking can be added by a couple of 3rd party activex controls we are using the wintertree spellchecker. We decided to go this way instead of just using word integration because you are then able to distribute a fully functional (word compatable) word processor with your application without dealing with office installations on users workstations etc. Mark Sergent InnSource Solutions Inc. mark@innsourcesolutions.com | |
Phil Jackson | Re: Using Word for notepad entry and for Mail Merge on Fri, 12 Dec 2008 09:18:13 +1300 Hi Mark You make a lot of sense! Are there any traps we need to be aware of, taking into account that we have no ActiveX experience? Cheers Phil Jackson Mark Sergent wrote: > On Thu, 11 Dec 2008 09:55:33 +1300, Phil Jackson wrote: > >> Word already provides spell checking and I wonder if the following is >> possible with ActiveX and xBase >> >> 1) Pop up a screen to edit/enter some text using Word - keep controls to >> a minimum. Use native ability to spellcheck / grammar check. Ideally the >> size of the screen is under my control. >> 2) Send text to clipboard as required. >> 3) Or, swap data fields for producing mail merge letters - saved as >> files (DOC or HTML) >> >> I have never used ActiveX but wonder if someone can point me in the >> right direction to get started. I am not averse to paying for someone's >> time if that saves me a great deal more time - if someone is already >> doing the above then that would be very good! >> >> I'm currently using 602Text which probably doesn't handle ActiveX and >> would install Word to get this working as needed. >> >> Cheers >> >> Phil Jackson > > Hi Phil, > > There is also an activex product called TXText Control that we are using in > our new application. It is a full activex word processor that creates a > number of file formats including office2003/2007 html pdf etc. It has full > mailmerge capabilities and spell checking can be added by a couple of 3rd > party activex controls we are using the wintertree spellchecker. > > We decided to go this way instead of just using word integration because > you are then able to distribute a fully functional (word compatable) word > processor with your application without dealing with office installations > on users workstations etc. > | |
Mark Sergent | Re: Using Word for notepad entry and for Mail Merge on Tue, 16 Dec 2008 09:23:34 -0800 On Fri, 12 Dec 2008 09:18:13 +1300, Phil Jackson wrote: > Hi Mark > > You make a lot of sense! Are there any traps we need to be aware of, > taking into account that we have no ActiveX experience? > > Cheers > > Phil Jackson > > > Mark Sergent wrote: >> On Thu, 11 Dec 2008 09:55:33 +1300, Phil Jackson wrote: >> >>> Word already provides spell checking and I wonder if the following is >>> possible with ActiveX and xBase >>> >>> 1) Pop up a screen to edit/enter some text using Word - keep controls to >>> a minimum. Use native ability to spellcheck / grammar check. Ideally the >>> size of the screen is under my control. >>> 2) Send text to clipboard as required. >>> 3) Or, swap data fields for producing mail merge letters - saved as >>> files (DOC or HTML) >>> >>> I have never used ActiveX but wonder if someone can point me in the >>> right direction to get started. I am not averse to paying for someone's >>> time if that saves me a great deal more time - if someone is already >>> doing the above then that would be very good! >>> >>> I'm currently using 602Text which probably doesn't handle ActiveX and >>> would install Word to get this working as needed. >>> >>> Cheers >>> >>> Phil Jackson >> >> Hi Phil, >> >> There is also an activex product called TXText Control that we are using in >> our new application. It is a full activex word processor that creates a >> number of file formats including office2003/2007 html pdf etc. It has full >> mailmerge capabilities and spell checking can be added by a couple of 3rd >> party activex controls we are using the wintertree spellchecker. >> >> We decided to go this way instead of just using word integration because >> you are then able to distribute a fully functional (word compatable) word >> processor with your application without dealing with office installations >> on users workstations etc. >> Hi Phil, Sorry for the delay getting back to you. There were a coupld of things we ran into using the controls. With the following settings on the xbpactivexcontrol they seem to run well in xbase. ::useGuiThread := .F. ::userEvents := .T. If you would like come code samples let me know on my private email and i will put something together for you. Have a great holiday Season. Mark Sergent InnSource Solutions Inc. mark@innsourcesolutions.com www.innsourcesolutions.com |