Programmatically copy text from screen in other application
 

I am building an Excel application in which I would like to have Excel go to
another application, copy a 7 digit number from a location on the screen,
then go back to Excel to work on that 7 digit number. The 7 digit number is
always in the same location of the screen of the other application (the app
is Kana www.kana.com). Basically, I want to automate the action of
highlighting with the mouse and copying (CTRL + C) the 7 digit number on the
screen in Kana. Once I have the number in the clipboard, I know how to get it
out of the clipboard and do what I want with it in Excel. The problem is
getting it into the clipboard from Kana. Can anyone point me in the right
direction to accomplish this?

Thanks in advance,

Steve