GeMIS_WEB/GUI/b-debhi.w

&ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
&ANALYZE-RESUME
/* Connected Databases 
          anadat           PROGRESS
*/
&Scoped-define WINDOW-NAME CURRENT-WINDOW
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS bTableWin 
/*------------------------------------------------------------------------

  File: adm2\src\browser.w

  Description: SmartDataBrowser Object

  Input Parameters:
      <none>

  Output Parameters:
      <none>

------------------------------------------------------------------------*/
/*          This .W file was created with the Progress AppBuilder.      */
/*----------------------------------------------------------------------*/

/* Create an unnamed pool to store all the widgets created 
     by this procedure. This is a good default which assures
     that this procedure's triggers and internal procedures 
     will execute in this procedure's storage, and that proper
     cleanup will occur on deletion of the procedure. */

CREATE WIDGET-POOL.

/* ***************************  Definitions  ************************** */

/* Parameters Definitions ---                                           */

/* Local Variable Definitions ---                                       */

DEFINE TEMP-TABLE tDebhi LIKE Debhi
    INDEX tDebhi-k1 IS PRIMARY 
    Firma Knr Datum Trnr.

{ incl/tmpbrowser.i }

{src/adm2/widgetprto.i}

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK 

/* ********************  Preprocessor Definitions  ******************** */

&Scoped-define PROCEDURE-TYPE SmartDataBrowser
&Scoped-define DB-AWARE no

&Scoped-define ADM-SUPPORTED-LINKS TableIO-Target,Data-Target,Update-Source

/* Include file with RowObject temp-table definition */
&Scoped-define DATA-FIELD-DEFS "d-debhi.i"

/* Name of designated FRAME-NAME and/or first browse and/or first query */
&Scoped-define FRAME-NAME F-Main
&Scoped-define BROWSE-NAME br_table

/* Internal Tables (found by Frame, Query & Browse Queries)             */
&Scoped-define INTERNAL-TABLES rowObject

/* Definitions for BROWSE br_table                                      */
&Scoped-define FIELDS-IN-QUERY-br_table rowObject.Datum rowObject.Faknr ~
rowObject.Kte rowObject.FRW rowObject.Kurs rowObject.Soll_FRW ~
rowObject.Soll rowObject.Haben_FRW rowObject.Haben rowObject.Skonto_FRW ~
rowObject.Skonto rowObject.Saldo 
&Scoped-define ENABLED-FIELDS-IN-QUERY-br_table 
&Scoped-define QUERY-STRING-br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION
&Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION.
&Scoped-define TABLES-IN-QUERY-br_table rowObject
&Scoped-define FIRST-TABLE-IN-QUERY-br_table rowObject


/* Definitions for FRAME F-Main                                         */

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS RECT-1 br_table 

/* Custom List Definitions                                              */
/* List-1,List-2,List-3,List-4,List-5,List-6                            */

/* _UIB-PREPROCESSOR-BLOCK-END */
&ANALYZE-RESUME


/* ************************  Function Prototypes ********************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD setZeilenfarbe bTableWin 
FUNCTION setZeilenfarbe RETURNS LOGICAL
    ( ipFarbe AS INT )  FORWARD.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


/* ***********************  Control Definitions  ********************** */


/* Definitions of the field level widgets                               */
DEFINE RECTANGLE RECT-1
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL   
     SIZE 160 BY 7.14.

/* Query definitions                                                    */
&ANALYZE-SUSPEND
DEFINE TEMP-TABLE RowObject NO-UNDO
    {{&DATA-FIELD-DEFS}}
    {src/adm2/robjflds.i}.

DEFINE QUERY br_table FOR 
      rowObject SCROLLING.
&ANALYZE-RESUME

/* Browse definitions                                                   */
DEFINE BROWSE br_table
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table bTableWin _STRUCTURED
  QUERY br_table NO-LOCK DISPLAY
      rowObject.Datum FORMAT "99.99.9999":U
      rowObject.Faknr FORMAT "zzzzz9":U
      rowObject.Kte FORMAT "x(04)":U
      rowObject.FRW FORMAT "x(03)":U
      rowObject.Kurs FORMAT "zzz9.9999":U
      rowObject.Soll_FRW COLUMN-LABEL "Soll FRW" FORMAT "zzz,zzz,zz9.99-":U
      rowObject.Soll FORMAT "zzz,zzz,zz9.99-":U
      rowObject.Haben_FRW COLUMN-LABEL "Haben FRW" FORMAT "zzz,zzz,zz9.99-":U
      rowObject.Haben FORMAT "zzz,zzz,zz9.99-":U
      rowObject.Skonto_FRW COLUMN-LABEL "Skonto FRW" FORMAT "zzz,zzz,zz9.99-":U
      rowObject.Skonto FORMAT "zzz,zz9.99-":U
      rowObject.Saldo FORMAT "zzz,zzz,zz9.99-":U
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
    WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS SIZE 158 BY 6.67.


/* ************************  Frame Definitions  *********************** */

DEFINE FRAME F-Main
     br_table AT ROW 1.48 COL 3 WIDGET-ID 200
     RECT-1 AT ROW 1.24 COL 2 WIDGET-ID 2
    WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY 
         SIDE-LABELS NO-UNDERLINE THREE-D 
         AT COL 1 ROW 1 SCROLLABLE  WIDGET-ID 100.


/* *********************** Procedure Settings ************************ */

&ANALYZE-SUSPEND _PROCEDURE-SETTINGS
/* Settings for THIS-PROCEDURE
   Type: SmartDataBrowser
   Data Source: "d-debhi.w"
   Allow: Basic,Browse
   Frames: 1
   Add Fields to: Neither
   Other Settings: PERSISTENT-ONLY COMPILE
 */

/* This procedure should always be RUN PERSISTENT.  Report the error,  */
/* then cleanup and return.                                            */
IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
          VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  RETURN.
END.

&ANALYZE-RESUME _END-PROCEDURE-SETTINGS

/* *************************  Create Window  ************************** */

&ANALYZE-SUSPEND _CREATE-WINDOW
/* DESIGN Window definition (used by the UIB) 
  CREATE WINDOW bTableWin ASSIGN
         HEIGHT             = 7.62
         WIDTH              = 162.
/* END WINDOW DEFINITION */
                                                                        */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB bTableWin 
/* ************************* Included-Libraries *********************** */

{src/adm2/browser.i}

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME




/* ***********  Runtime Attributes and AppBuilder Settings  *********** */

&ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
/* SETTINGS FOR WINDOW bTableWin
  NOT-VISIBLE,,RUN-PERSISTENT                                           */
/* SETTINGS FOR FRAME F-Main
   NOT-VISIBLE FRAME-NAME Size-to-Fit                                   */
/* BROWSE-TAB br_table RECT-1 F-Main */
ASSIGN 
       FRAME F-Main:SCROLLABLE       = FALSE
       FRAME F-Main:HIDDEN           = TRUE.

/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


/* Setting information for Queries and Browse Widgets fields            */

&ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table
/* Query rebuild information for BROWSE br_table
     _TblList          = "rowObject"
     _Options          = "NO-LOCK INDEXED-REPOSITION"
     _FldNameList[1]   > _<SDO>.rowObject.Datum
"rowObject.Datum" ? ? "date" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[2]   = _<SDO>.rowObject.Faknr
     _FldNameList[3]   = _<SDO>.rowObject.Kte
     _FldNameList[4]   > _<SDO>.rowObject.FRW
"rowObject.FRW" ? ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[5]   > _<SDO>.rowObject.Kurs
"rowObject.Kurs" ? ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[6]   > _<SDO>.rowObject.Soll_FRW
"rowObject.Soll_FRW" "Soll FRW" ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[7]   = _<SDO>.rowObject.Soll
     _FldNameList[8]   > _<SDO>.rowObject.Haben_FRW
"rowObject.Haben_FRW" "Haben FRW" ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[9]   = _<SDO>.rowObject.Haben
     _FldNameList[10]   > _<SDO>.rowObject.Skonto_FRW
"rowObject.Skonto_FRW" "Skonto FRW" ? "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[11]   = _<SDO>.rowObject.Skonto
     _FldNameList[12]   = _<SDO>.rowObject.Saldo
     _Query            is NOT OPENED
*/  /* BROWSE br_table */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
/* Query rebuild information for FRAME F-Main
     _Options          = "NO-LOCK"
     _Query            is NOT OPENED
*/  /* FRAME F-Main */
&ANALYZE-RESUME

 



/* ************************  Control Triggers  ************************ */

&Scoped-define BROWSE-NAME br_table
&Scoped-define SELF-NAME br_table
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON CTRL-END OF br_table IN FRAME F-Main
DO:
        APPLY "END":U TO BROWSE {&BROWSE-NAME}.
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON CTRL-HOME OF br_table IN FRAME F-Main
DO:
        APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON DEFAULT-ACTION OF br_table IN FRAME F-Main
DO:
    {src/adm2/brsdefault.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON END OF br_table IN FRAME F-Main
DO:
    {src/adm2/brsend.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON HOME OF br_table IN FRAME F-Main
DO:
    {src/adm2/brshome.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON LEFT-MOUSE-CLICK OF br_table IN FRAME F-Main
DO:
        APPLY 'ENTRY' TO {&BROWSE-NAME}.
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON LEFT-MOUSE-DBLCLICK OF br_table IN FRAME F-Main
DO:
        IF NOT VALID-HANDLE( hFenster ) THEN RETURN NO-APPLY.
        RUN TOOLBAR IN hFenster ( INPUT 'UPDATE' ).
        RETURN NO-APPLY.
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON OFF-END OF br_table IN FRAME F-Main
DO:
    {src/adm2/brsoffnd.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON OFF-HOME OF br_table IN FRAME F-Main
DO:
    {src/adm2/brsoffhm.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON ROW-ENTRY OF br_table IN FRAME F-Main
DO:
    {src/adm2/brsentry.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON ROW-LEAVE OF br_table IN FRAME F-Main
DO:
    {src/adm2/brsleave.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON SCROLL-NOTIFY OF br_table IN FRAME F-Main
DO:
        {src/adm2/brsscrol.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON START-SEARCH OF br_table IN FRAME F-Main
DO:
        { incl/brwstartsearch.i }
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
ON VALUE-CHANGED OF br_table IN FRAME F-Main
DO:
    {src/adm2/brschnge.i}
    END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&UNDEFINE SELF-NAME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK bTableWin 


/* ***************************  Main Block  *************************** */

{ incl/brwmainblock.i }
/*    { incl/brwinternproc.i }*/

PROCEDURE FILTER_SETZEN:
    { incl/brwfilter.i }
END PROCEDURE.

PROCEDURE EXPORT_EXCEL:
    RUN DEBHI_EXPORT_EXCEL.
END PROCEDURE.

PROCEDURE ZURUECKSETZEN:
    { incl/brwresetbreitespalte.i }
END PROCEDURE.

PROCEDURE SORTIERBAR:
    DEF INPUT PARAMETER ipSort  AS HANDLE   NO-UNDO.
    DEF INPUT PARAMETER ipMove  AS HANDLE   NO-UNDO.

    DEF VAR hBrowser AS HANDLE NO-UNDO.

    ipMove:CHECKED = FALSE.
    ipSort:CHECKED = TRUE .
    hBrowser  = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
    hBrowser:COLUMN-MOVABLE         = FALSE.
    hBrowser:ALLOW-COLUMN-SEARCHING = TRUE.
END PROCEDURE.

PROCEDURE VERSCHIEBBAR:
    DEF INPUT PARAMETER ipMove  AS HANDLE   NO-UNDO.
    DEF INPUT PARAMETER ipSort  AS HANDLE   NO-UNDO.

    DEF VAR hBrowser AS HANDLE NO-UNDO.

    ipSort:CHECKED = FALSE.
    ipMove:CHECKED = TRUE .
    hBrowser  = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
    hBrowser:ALLOW-COLUMN-SEARCHING = FALSE.
    hBrowser:COLUMN-MOVABLE         = TRUE.
END PROCEDURE.
    
PROCEDURE ShellExecuteA EXTERNAL "shell32.dll":
    DEF INPUT  PARAMETER hwnd           AS LONG.   /* Handle to parent window */
    DEF INPUT  PARAMETER lpOperation    AS CHAR.   /* Operation to perform: open, print */
    DEF INPUT  PARAMETER lpFile         AS CHAR.   /* Document or executable name */
    DEF INPUT  PARAMETER lpParameters   AS CHAR.   /* Command line parameters to executable in lpFile */
    DEF INPUT  PARAMETER lpDirectory    AS CHAR.   /* Default directory */
    DEF INPUT  PARAMETER nShowCmd       AS LONG.   /* whether shown when opened: 
                                                          0 hidden, 1 normal, minimized 2, maximized 3, 
                                                          0 if lpFile is a document */
    DEF RETURN PARAMETER hInstance      AS LONG.   /* Less than or equal to 32 */
END PROCEDURE.

    &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN          
        RUN initializeObject.        
    &ENDIF

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


/* **********************  Internal Procedures  *********************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DEBHI_EXPORT_EXCEL bTableWin 
PROCEDURE DEBHI_EXPORT_EXCEL :
/*------------------------------------------------------------------------------*/
    /*  Purpose:     Super Override                                                 */
    /*  Parameters:                                                                 */
    /*  Notes:                                                                      */
    /*------------------------------------------------------------------------------*/

    DEFINE VARIABLE iKnr      AS INTEGER          NO-UNDO.
    DEFINE VARIABLE rDebhi    AS RECID            NO-UNDO.
    DEFINE VARIABLE Rundbetr  AS DECIMAL          NO-UNDO.
    DEFINE VARIABLE cFwFrw    AS CHARACTER        NO-UNDO.

    DEFINE VARIABLE Vorlage   AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE Datei     AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE Daten     AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE cParam    AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE Zelle     AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE io        AS LOG              NO-UNDO.
    DEFINE VARIABLE excelAppl AS COMPONENT-HANDLE NO-UNDO.

    rDebhi = DYNAMIC-FUNCTION ('getCurrentRecid':U IN hDaten) NO-ERROR.

    IF  rDebhi = ? OR 
        rDebhi = 0 THEN RETURN NO-APPLY.
    FIND Debhi NO-LOCK WHERE RECID(Debhi) = rDebhi NO-ERROR.
    IF NOT AVAILABLE Debhi THEN RETURN NO-APPLY.
    
    iKnr = Debhi.Knr.
    RELEASE Debhi.
    
    cFwFrw = DYNAMIC-FUNCTION ('getFwFrw':U) NO-ERROR.

    EMPTY TEMP-TABLE tDebhi.
    FOR EACH Debhi USE-INDEX Debhi-k2
        WHERE Debhi.Firma = D1Firma
        AND   Debhi.Knr   = iKnr NO-LOCK:
            
        CREATE tDebhi.
        BUFFER-COPY Debhi TO tDebhi.
        ASSIGN 
            tDebhi.Saldo = 0.
    END. 

    Vorlage = 'DebHist.xlsm'.
    Datei   = 'DebHist.xlsm'.
    Daten   = SESSION:TEMP-DIR + 'DebHist.csv'.

    cParam = Datei + CHR(01) + Vorlage.
    RUN CREATEDATEI ( INPUT cParam ).
    IF RETURN-VALUE BEGINS 'ERROR' THEN RETURN NO-APPLY.
    Datei = RETURN-VALUE.
    
    excelAppl = DYNAMIC-FUNCTION('CREATEEXCEL':U) NO-ERROR.
    IF NOT VALID-HANDLE(excelAppl) THEN 
    DO:
        MESSAGE 'Die Applikation Excel konnte nicht gestartet werden ! '
            VIEW-AS ALERT-BOX ERROR.
        RETURN NO-APPLY.
    END.

    OUTPUT TO VALUE(Daten).

    FIND Adresse USE-INDEX Adresse-k1
        WHERE Adresse.Firma = AdFirma
        AND   Adresse.Knr   = iKnr     NO-LOCK.

    PUT CONTROL STRING(Adresse.Knr,'999999')    CHR(10)
        Adresse.Anschrift[06]           CHR(10)
        Adresse.Anschrift[07]           CHR(10)
        Adresse.Anschrift[08]           CHR(10)
        Adresse.Anschrift[09]           CHR(10)                                 
        Adresse.Anschrift[10]           CHR(10)
        Adresse.Anschrift[11]           CHR(10)
        '£' CHR(10) '£' CHR(10)
        '£Datum£Faknr£Kte£Frw£Soll Frw£Soll£Haben Frw£Haben£Skonto Frw£Skonto£Saldo Frw'  CHR(10) '£' CHR(10).

    Rundbetr = 0.
    FOR EACH tDebhi BREAK
        BY tDebhi.Firma
        BY tDebhi.Knr
        BY tDebhi.Datum
        BY tDebhi.Trnr:
      
        IF FIRST-OF (tDebhi.Knr) THEN Rundbetr = 0.
        IF tDebhi.Frw = cFwFrw THEN Rundbetr = Rundbetr + tDebhi.Soll     - tDebhi.Haben     - tDebhi.Skonto.
        ELSE                        Rundbetr = Rundbetr + tDebhi.Soll_FRW - tDebhi.Haben_FRW - tDebhi.Skonto_FRW.

        PUT CONTROL                                 '£'
            STRING(tDebhi.Datum,'99.99.9999')       '£'
            STRING(tDebhi.Faknr,'>>>>>>9')          '£'
            tDebhi.Kte                              '£'
            tDebhi.Frw                              '£'.
        IF tDebhi.Soll   <> 0 THEN PUT CONTROL TRIM(STRING(tDebhi.Soll_FRW  ,'->>>>>>>>9.99')) '£' TRIM(STRING(tDebhi.Soll  ,'->>>>>>>>9.99')) '£'.
        ELSE                       PUT CONTROL '££'.
        IF tDebhi.Haben  <> 0 THEN PUT CONTROL TRIM(STRING(tDebhi.Haben_FRW ,'->>>>>>>>9.99')) '£' TRIM(STRING(tDebhi.Haben ,'->>>>>>>>9.99')) '£'.
        ELSE                       PUT CONTROL '££'.
        IF tDebhi.Skonto <> 0 THEN PUT CONTROL TRIM(STRING(tDebhi.Skonto_FRW,'->>>>>>>>9.99')) '£' TRIM(STRING(tDebhi.Skonto,'->>>>>>>>9.99')) '£'.
        ELSE                       PUT CONTROL '££'.
        PUT CONTROL STRING(Rundbetr,'->>>>>>>>9.99')    CHR(10).
    END.
    OUTPUT CLOSE.
    
    RUN OPENEXCEL ( INPUT excelAppl,
        INPUT Datei,
        INPUT '',
        OUTPUT io ).
    IF NOT io THEN 
    DO:
        RUN FEHLER ( INPUT 1040 ).
        RETURN NO-APPLY.
    END.

    Zelle = 'A1'.
    excelAppl:Range(Zelle):SELECT.
    excelAppl:Selection:FormulaR1C1 = 'TEXT;' + Daten.
    excelAppl:Application:RUN ( 'DateiEinfügen' ).

    Zelle = 'A1'.
    excelAppl:Range(Zelle):SELECT.
    excelAppl:Selection:ColumnWidth = 0.3.
    
    DYNAMIC-FUNCTION('RELEASEEXCEL':U, INPUT excelAppl ) NO-ERROR.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE destroyObject bTableWin 
PROCEDURE destroyObject :
/*------------------------------------------------------------------------------
      Purpose:     Super Override
      Parameters:  
      Notes:       
    ------------------------------------------------------------------------------*/

    DEF VAR hBrowser AS HANDLE NO-UNDO.

    hBrowser = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
    DYNAMIC-FUNCTION('setBrowserDaten':U, INPUT hBrowser,
        INPUT Sektion ) NO-ERROR.

    RUN SUPER.

/* Code placed here will execute AFTER standard behavior.    */

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin  _DEFAULT-DISABLE
PROCEDURE disable_UI :
/*------------------------------------------------------------------------------
  Purpose:     DISABLE the User Interface
  Parameters:  <none>
  Notes:       Here we clean-up the user-interface by deleting
               dynamic widgets we have created and/or hide 
               frames.  This procedure is usually called when
               we are ready to "clean-up" after running.
------------------------------------------------------------------------------*/
  /* Hide all frames. */
  HIDE FRAME F-Main.
  IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_BROWSE bTableWin 
PROCEDURE ENTRY_BROWSE :
/*------------------------------------------------------------------------------
      Purpose:     
      Parameters:  <none>
      Notes:       
    ------------------------------------------------------------------------------*/

    APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject bTableWin 
PROCEDURE initializeObject :
/*------------------------------------------------------------------------------
      Purpose:     Super Override
      Parameters:  
      Notes:       
    ------------------------------------------------------------------------------*/

    { incl/brwinitialize.i }

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

/* ************************  Function Implementations ***************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION setZeilenfarbe bTableWin 
FUNCTION setZeilenfarbe RETURNS LOGICAL
    ( ipFarbe AS INT ) :
    /*------------------------------------------------------------------------------
      Purpose:  
        Notes:  
    ------------------------------------------------------------------------------*/

    { incl/brwsetzeilenfarbe.i }

END FUNCTION.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME