Not sure if anything like this can be done! We work with
a propriatary software product builds an SQL statement
with the data that we key in. It has an input box that we
key in numbers to, select an 'and' or 'or' option, then we
push a control button (titled ADD) to have the program
build the statement. An example would be I enter number
123 then select 'Add', place the cursor in the input box
again, enter 234, and repeat the process. The SQL being
built looks like -
Number = 123
or
Number = 234
or
Etc.
We receive a list in excel of many numbers and this
becomes a tedious manual cut and paste routine from excel
to the other program. Is there any macro commands that
will make the other program resond to a paste and then
enter command???
Thanks