Page 1 of 1

Calling Excel/Word query

Posted: Fri Aug 07, 2009 11:41 am
by ConvertFromOldNGs
by Silver Springs ... >> Tue, 27 Apr 1999 22:31:59 GMT

Hi
I make copious use of the app.createExternalProcess and shellExecute (in shell32.DLL) functions for calling Windows programs (like Outlook, Excel, Word) in my JADE applications.

However, when calling Word or Excel then if these applications are already open I'd like to be able to open another Word window or Excel worksheet in the loaded Windows program rather than invoking a separate instance of Word or Excel.

Has anybody out there done this ?

SilverSprings ...

e-mail : silversprings@easyliving.com

Re: Calling Excel/Word query

Posted: Fri Aug 07, 2009 11:41 am
by ConvertFromOldNGs
by Torrie Moore >> Wed, 28 Apr 1999 23:10:42 GMT

You will need to use the OLE interface provided with word, excel etc. To do this you will need to create an activeX control in VB, Delphi, C etc that maps to the word OLE functions you wish to use. (Jade only allows you to call the primary, show, open and hide functions when using an OleControl) Run the functions on the ActiveX control to open word and load documents etc. This will give you the ability to load multiple documents, print them etc from within Jade. Check the Word Visual Basic Help file for the functions that you can use.

Torrie Moore
Concept Engineering

Re: Calling Excel/Word query

Posted: Fri Aug 07, 2009 11:41 am
by ConvertFromOldNGs
by Eric Peachey >> Fri, 30 Apr 1999 7:08:32 GMT
You will need to use the OLE interface provided with word, excel etc. To do this you will need to create an activeX control in VB, Delphi, C etc that maps to the word OLE functions you wish to use.

If all Alan wants to do is to open a document then the existing Jade OleControl should do the trick. Opening additional documents via olecontrol brings them up as additional child windows in Word.

Eric
Eng Cent Dunedin