Printable View
I am using VBA in my xls spreadsheet. I opening a third party app using the shell command. The app opens and I use sendkeys to tab 3 times on the app. This works great... the problem is when I try to send sendkeys "^c" the field which is highlighted on the app is not being copied using the sendkeys "^c".... any ideas what is wrong? Again I am able to send tab 3 times to the app... the problem is the highlited contents on the app is not being copied to the clipboard...
help help
Try
The problem could be that sendkeys is unreliable and depends upon the other app having the focus.VB Code:
Try slowing it down so the commands dont execute one right after another.
I tried that... but it seems the app looses focus... how can i set the focus on the app before doing a copy?
You will need to use some API calls. If you do not have the API VIewer and API Guide then I suggest you download them from allapi.net.
Here is one of their tips which activates another programs main window.
http://www.mentalis.org/tips/tip006.shtml
are you useing a separate sendkeys statement to send the ^C?
try sending it in the same string as the tabs.
also if the other app has a menu, you could try sending alt e c
pete