Recent content by sphipp

What I normally do is to have a blank Excel Spreadsheet that contains all the macros that I need, then I copy that to my new name, open the new spreadsheet, make the changes and save it. That way, I don't have to worry about messing about with macros. Do you have macros that are particular to...

It's always easier to understand a question if it is split into several smaller posts, each asking one thing, rather than one long post asking a lot of things. Browses in Progress are good for displaying and choosing information but that's about it, in my opinion. If you want to do some work...

Is lp extension/context-aware? I didn't think it was, at least I have gone through a ream of paper by using it in the past.

That's quite tricky under Unix, at least I think it is. Finding the files in a directory is fairly easy - OS-DIR gives you the list of files, you can import them into a Temp-Table and then process each one individually. However, printing each file is the difficult part. Under Windows you...

Change IF istaskrunning (INPUT pi_cProgram,INPUT pi_cTitle, OUTPUT ProcessID) THEN DO: RUN OpenProcess ({&PROCESS_TERMINATE}, 0, INT (ProcessId), OUTPUT ProcessHandle). IF ProcessHandle NE 0 THEN DO: RUN TerminateProcess (ProcessHandle, 0, OUTPUT ReturnValue). RUN...

for each SupportCall where SupportCall.AssignedTo = 'fred' no-lock: /* Do something */ end. To amend the records use exclusive-lock

message program-name (2) view-as alert-box.

Using some code from OEHive http://www.oehive.org/node/513: &GLOB PROCESS_TERMINATE 1 PROCEDURE OpenProcess EXTERNAL "kernel32" : DEFINE INPUT PARAMETER dwDesiredAccess AS LONG. DEFINE INPUT PARAMETER bInheritHandle AS LONG. DEFINE INPUT PARAMETER dwProcessId AS LONG...

If you have a play with tasklist then you can extract the title of the web page that is running. FUNCTION IsTaskRunning RETURNS LOGICAL (pi_cTask AS CHARACTER, pi_cTitle AS CHARACTER): DEFINE VARIABLE cline AS CHARACTER NO-UNDO EXTENT 20. DEFINE VARIABLE lRunning AS LOGICAL NO-UNDO...

Try: FUNCTION TaskIsRunning RETURNS LOGICAL (pi_cTask AS CHARACTER): DEFINE VARIABLE cline AS CHARACTER NO-UNDO. DEFINE VARIABLE lTaskFound AS LOGICAL NO-UNDO. ASSIGN pi_ctask = TRIM (pi_ctask). INPUT THROUGH VALUE ('tasklist') NO-ECHO. REPEAT: IMPORT cline NO-ERROR. IF...

Try DEFINE VARIABLE cTest AS CHARACTER NO-UNDO. DEFINE VARIABLE hfrmain AS HANDLE NO-UNDO. DEFINE VARIABLE htest AS HANDLE NO-UNDO. DEFINE VARIABLE hBtnOK AS HANDLE NO-UNDO. DEFINE BUTTON btnOK LABEL "OK". DEFINE FRAME frmain ctest VIEW-AS EDITOR SIZE 50 BY 5 AT ROW 1...

Try something like this: DEFINE VARIABLE cTest AS CHARACTER NO-UNDO. DEFINE VARIABLE hfrmain AS HANDLE NO-UNDO. DEFINE VARIABLE htest AS HANDLE NO-UNDO. DEFINE VARIABLE hBtnOK AS HANDLE NO-UNDO. DEFINE BUTTON btnOK LABEL "OK". DEFINE FRAME frmain ctest VIEW-AS EDITOR...

Thanks - that's what I thought I had typed and that's what I was sure I had typed, but the code imps muddled it up for me.

DISPLAY "~{". or DISPLAY CHR(123).

Re: Error occurred while accessing component property/method: <property or method nam What this means is that you have an invalid COM handle. Normally, you get this by trying to refer to a COM handle that you haven't yet created. So, if you want to create a Chart in Excel but don't create...