The OpenEdge Hive

Question

In the AppBuilder or Procedure Editor, whenever I choose File -> Open it starts in the last directory I used, not my working directory like it used to. How do I get it to start in the initial directory defined in the Windows shortcut?

Answer

There are a couple solutions for this.

First you can modify adecomm/_getfile.p (yank it from adecomm.pl) by adding the line "initial-dir '.'" to the first system-dialog get-file command you will find there.

Second, you can use Tweak UI to customize the "Places Bar" that appears in the file-open dialog-box to include the directories for the projects you work on.

Question

Tips and examples for communicating with MS-Excel.

Answer

by Jeff Pilant

Sites with information to write *.XLS directly:

http:sc.openoffice.org/excelfileformat.pdf

http:www.sector13.org/jason/xls/

http:www.wotsit.org/search.asp?s=CEL

http:chicago.sourceforge.net/xlhtml/

----

Some Excel tricks:

1) To speed up the excel generation, you can disable the screen updating with the following:

chExcelApplication:ScreenUpdating = False.

and restore it with

chExcelApplication:ScreenUpdating = True.

Question

How do I send an email through Progress?

Answer

There are many solutions:

A1: Use the smtpmail.p program from www.freeframework.org

A2: os-command no-wait value("start mailto:bush@whitehouse.gov").

A3: see send email through Outlook using its COM-interface

A4: see for MAPI

A5: to send email through the COM-interface of Lotus Notes, see page 553

We are using Lotus Notes instead of Outlook. How can we send e-mail with Notes?

Answer

Found on Peg, sent by Torben Jensby Christensen on 13 december 2002.

/* Procedure to send mail using Lotus Notes 4.6
 *
 * Has been tested to work with
 *    Lotus Notes 4.6.7
 *
 * 16.06.2000 TJC Created
 * 30.07.2000 TJC modified to find users mail file
 */
DEFINE INPUT PARAMETER msgRecip  AS CHAR NO-UNDO.
DEFINE INPUT PARAMETER msgTitle  AS CHAR NO-UNDO.
DEFINE INPUT PARAMETER msgBody   AS CHAR NO-UNDO.
DEFINE INPUT PARAMETER msgAttach AS CHAR NO-UNDO.
  

Are there free or cheap alternatives for webspeed?

Some of the FAQ pages rescued from global-shared.com