Page 2 of 2

Re: Interfacing with Excel

Posted: Fri Aug 07, 2009 11:11 am
by ConvertFromOldNGs
by Grant Samuels >> Wed, 24 Feb 1999 20:29:48 GMT

By popular demand here is the shell32 posting (originally posted by Geoff Davies)...
------------------------------------------------------------------------------------------------------------------ Pretty straightforward. Here are the instructions for setting up an external function.

1. From the Schema Browser or Class Browser, select the Browse | External Functions menu command.

2. Select the Library | Add Library command.

3. Type shell32 in the Name textbox and click OK.

4. Select the Functions | Add... menu command.

5. Type shellExecute in the Name textbox and press Tab.

6. Type ShellExecuteA in the Entry Point textbox and click OK.

7. Alter the signature of the shellExecute external function to:

shellExecute( hwnd:Integer; lpOperation:String; lpFile:String; lpParameters:String; lpDirectory : String; nShowHow : Integer) : Integer is ShellExecuteA in shell32;

8. Press F8 to compile.

Now all you have to do is call the external function in a JADE method. The following instruction opens your e-mail program and prefill the mailto: field

call shellExecute (hwnd, "open", "mailto:JADESupport@cardinal.co.nz", null, null, 1);

The following instruction opens your internet browser and load the appropriate URL

call shellExecute (hwnd, "open", "http://www.jade.co.nz", null, null, 1);

Re: Interfacing with Excel

Posted: Fri Aug 07, 2009 11:11 am
by ConvertFromOldNGs
by Robert Barr >> Thu, 15 Jul 1999 21:23:03 GMT

I'd be interested to learn if anyone has gone to the trouble of reading or writing XLS format data in JADE?

If so, would you be willing to (a) share your code, or (b) share your experience - was it straighforward, or fraught with hidden complexities and documentation ommissions?

Cheers,
Rob