Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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

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

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...

...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...

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...

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

...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...

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...

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...

Thanks! At least some good thing resulted from this! Regards, Tom

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...

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...