View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Excel Copy/Paste Macro to another open application. QWS3270

It may be better to transfer the data through a file. Can you have the
QWS3270 check every 5 seconds to see if a file exists. You can have EXCEL
generate the file with the data. then when QWS3270 see the file it can read
the data and continue. QWS3270 can also delete the file. The file can be
used as a semaphore to synchronize the two programs.

" wrote:

I have data in a series of spreadsheet cell's that needs to be keyed
one at a time to another application called QWS3270. I am running
macros within QWS3270 that wait's for a user input that can be pasted
from the windows clipboard.

The data will always be in specifc cells so a basic script to copy
each cell location to the clipboard will work but the trouble I am
having is how to have excel call the QWS3270 window active and paste
the data to the waiting prompt and then send an "Enter" keystroke in
the QWS3270 window before returning to excel for the next cell.

It's Excel 2003 running under XP

Thanks!