Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: 6volt
  • Order by date
  1. 6volt

    Delphi CreateProcess App Keystroke Automation: Can Window Handle Change?

    Thanks, The SendKeys code is simple and you can see the keybd_event calls. What is interesting is that the same code runs on many XP PC's and a lone Vista one, and most of the time, this won't happen for many months. Then one PC gets buggy with this. It's not clear how the Message Buffer...
  2. 6volt

    Delphi CreateProcess App Keystroke Automation: Can Window Handle Change?

    UPDATE: Turns out the Window Handle and Title are intact, but the window is unresponsive to any automation attempts to close it. I try these and they all fail to close the window: 0) Check Focus, Report, and SetFocus if required. 1) Send Closing SENDkeys again (CloseKey = F12, ENTER, Y...
  3. 6volt

    Delphi CreateProcess App Keystroke Automation: Can Window Handle Change?

    Thanks for the reply! Unfortunately, he code has nothing to do with the reality of the question. I just need a Yes or No answer with a short explanation if Yes so I can proceed to troubleshoot. Unfortunately, I need to know this first so I'm not out on a Wild Goose Chase...
  4. 6volt

    Delphi CreateProcess App Keystroke Automation: Can Window Handle Change?

    I'm automating a software using SendKeys. The s/w is executed in my Delphi 7 code by CreateProcess. The first time I want to sendkeys, I get the window handle by a title search. Then I use than handle subsequently. Everything works like it should but sometimes, typically when sending...
  5. 6volt

    How to Raise Exception from a ShellExecuted Delphi program into the Parent Delphi program

    Hi, Thanks for the ErrorLevel suggestion. However, I'm not sure exactly how it works: 1) Does it report the Last Error any process incurred? If Yes, you would not know when that error occurred - it could have been from hours or days ago. 2) OR, Does it report the Error of the last process to...
  6. 6volt

    How to Raise Exception from a ShellExecuted Delphi program into the Parent Delphi program

    I have a Delphi program, A, which runs another Delphi program, B, using CreateProcess (or ShellExecute) The return code from CreateProcess merely indicates whether the process was successfully created so it is useless when trying to RAISE ERRORS. The only way I can think of doing it is to have...
  7. 6volt

    Nested Try/Excepts to Traceback Errors

    Griffyn, We think alike! First, at this time, the code is Research Code and only I run it. It will advance to Research Code that "other people" run, and then finally a Production Code. Obviously, all the things you said apply to this, especially as it progresses to Production Code. Part of...
  8. 6volt

    Nested Try/Excepts to Traceback Errors

    I thought I was doing this properly over the years but just realized I'm doing it wrong when I was losing an Out of Bounds OS exception. My general approach when I write code is to encapsulate every routine with a T/E and append the E.messages so that I get a Traceback list of the calling...
  9. 6volt

    Excel INDIRECT VLOOKUP in another file with Variable File Name

    It was the "G" that worked. VLOOKUP of a vector does not work. I was jumping the gun because I had subsequent need to do a MATCH on the Date Column A. Oh well, at least I got it. Sorry for the post since can't delete. Tom
  10. 6volt

    Excel INDIRECT VLOOKUP in another file with Variable File Name

    Stumbled onto one that works: VLOOKUP(RC3,INDIRECT("'["&test1&".csv]"&test1&"'!$A$1:$G$"&COUNTA('^rut.csv'!C1)),2,FALSE) What was different... Thanks Tom
  11. 6volt

    Excel INDIRECT VLOOKUP in another file with Variable File Name

    I have 2 XL files: one with Data (call it A), another that uses it (call it B). File A is named ^rut.csv and has one sheet named ^rut. It is open when B is opened. A is a table of data where DATE in the first column is LOOKed UP. The following works: In B, Cell R3C4 defines the A...
  12. 6volt

    Excel are Descriptive Column Names possible?

    ...concept is almost there but it would be cumbersome in a formula: ( I know you can't assign a value to INDEX !) INDEX(Area,24) = INDEX(Length,11) * INDEX(Width,2) But Area24 = Length11 * Width2 would be great. Consider that in code you would have area(24) = length(11) * width(2) which is...
  13. 6volt

    Excel are Descriptive Column Names possible?

    I think this might clarify what I'm thinking of: If you name cell A1 "Length", any time you use "LENGTH" in a formula, it is identical to $A$1. I'm after something like that. I associate the name "TEMP" with the column name "D" so anywhere I would use D, such as D1, $D$1, D$1, etc. I could...
  14. 6volt

    Excel are Descriptive Column Names possible?

    It looks like this would work if you are calculating on the same row, however if you are jumping all over the place row-wise, I guess it won't work, right? And then everything must work with INDIRECT, ADDRESS, etc. too. Thanks Tom
  15. 6volt

    Excel are Descriptive Column Names possible?

    ...to rename the column "name", i.e. A,B,C,... etc? Because Columns are usually variable names, and Rows are usually indices Example: R12 = A1 + B2*C17*FF37 has absolutely no intuitive meaning. But the following does: Efficiency12 = Temp1 + Pres2*Velocity17*Length37 I find that when I...
  16. 6volt

    Use filename in cell as a string in a Range filename reference

    Yes, I goofed and posted this under VBA. However, I have discovered the INDIRECT method and it works when I put the entire RANGE in a cell, A1, and then do an INDIRECT (A1). However, I tried for a couple hours trying to use that method where I only put the filename in A1, leaving the filetype...
  17. 6volt

    Use filename in cell as a string in a Range filename reference

    Sounds complicated but I want to use this cell formula which references another file, ^rut.csv. =VLOOKUP(RC3,'^rut.csv'!R1C1:R6163C7,2,FALSE) Cell A1 has a value of ^rut I've tried replacing the '^rut in the formula with 1) A1 & ' 2) 'A1' & ' Doesn't work. I've tried replacing the entire...
  18. 6volt

    Excel Automation Open Existing XL File eOleException (DESPERATE)

    Thanks! At least some good thing resulted from this! Regards, Tom
  19. 6volt

    Excel Automation Open Existing XL File eOleException (DESPERATE)

    Problem Solved and it was stupid. Turns out the XL file was corrupt. I opened it up at least twice until I put some showmessages in the code to stop right before I opened it so I could try opening it through explorer and I guess I finally clicked on the right file. In my defense, the file...
  20. 6volt

    Excel Automation Open Existing XL File eOleException (DESPERATE)

    This post is an act of DESPERATION. This is code I have written and used for years and now, out of the blue, I cannot open an existing XL file. The code is the traditional: Excel: = CreateOleObject (' excel.application '); ... Excel. Workbooks. Open (LongFileName1); ... Excel. Workbooks...

Part and Inventory Search

Back
Top