Recent content by Scleameth

No sorry... I normally record a macro in Excel while doing what my intention with Progress is. You can basically use the Excel code directly in Progress, replacing the VB format of, say Range("A1").Font.ColorIndex to Progress format - Range("A1"):Font:ColorIndex. Progress can't interpret...

here's some code for colors and borders. You can play around with the borders to get more results, I'm sure... DEFINE VARIABLE chExcel AS COM-HANDLE NO-UNDO. DEFINE VARIABLE chBook AS COM-HANDLE NO-UNDO. DEFINE VARIABLE chSheet AS COM-HANDLE NO-UNDO. DEFINE VARIABLE i AS INTEGER...

nasty ! and if you try this : chWorkbook = chExcelApp:Workbooks:OPEN(pi_cImportFile,,FALSE) NO-ERROR. ?? If not that, then - I suppose I don't have the answer, sorry Edit: I just checked some code, but even if I include all security that Excel allows me, I don't get an error in the line...

You can disable excel alerts before you open the workbook: chExcelApp:DisplayAlerts = FALSE

ASSIGN char_var = STRING(dec_var).

Hi, some quick code: DEFINE VARIABLE chExcel AS COM-HANDLE NO-UNDO. DEFINE VARIABLE chBook AS COM-HANDLE NO-UNDO. DEFINE VARIABLE chSheet AS COM-HANDLE NO-UNDO. DEFINE VARIABLE chNSheet AS COM-HANDLE NO-UNDO. DEFINE VARIABLE cChar AS CHARACTER NO-UNDO INITIAL "This...

Hi, I'm not sure if this is the best way, but it's a way: DEFINE VARIABLE r1 AS INTEGER NO-UNDO. DEFINE VARIABLE r2 AS INTEGER NO-UNDO. DEFINE VARIABLE r3 AS INTEGER NO-UNDO. ASSIGN r1 = RANDOM(1, 50). DO WHILE r1 >= r2: ASSIGN r2 = RANDOM(1, 50). ASSIGN r1 = MIN(r1, r2). END...

IF INT(HourChar) > 24 THEN...

Looks like you are trying to get a start date and end date of the next month ? here is some code that might help - no need to validate which month you are working with: ASSIGN s_date1 = s_date1 - DAY(s_date1) + 32 s_date1 = s_date1 - DAY(s_date1) + 1 e_date1 =...

Thanks ! This sounds like a viable option, but would you mind telling me how exactly you included that extra information ?

Since this is my first post here, I'll give a quick 'sup to you all !! 'sup ? :) My company runs version 9.1D. I need to check which is the most recent compiled version of any program... In all .p files is the variable "&scop object-version" but when the program is compiled, how can I access...