VBA Questions

[bellram81]

Hello!, i have been trying to use send keys in a application(not a web app.) but it was not working. I have used sendkeys and application.sendkeys even though it was not working. Pls tell another codes. in that window i want to press f11 and f12 and also file menus.

 

[John_w]

Try calling AppActivate first:

AppActivate "Title of application window"  'change string to the full title of the application's window or the string it begins with
SendKeys "{F11}"    'F11
SendKeys "%FI"      'Alt F I

If the application conforms to Windows standards then file menus are accessed by pressing the Alt key followed by one or more keys, as shown.

VBA SendKeys is very unreliable and if it doesn't work you could try this SendKeys emulator which allows you to specify the window which receives the key presses. Download the VB6 version and put the code in a VBA module and it should compile after making some minor edits.

 

[bellram81]

Yes, i have used the same coding what you have given here, Even though it was not working. That appln is more secure even we cant select or copy anything. Then how can i use sendkeys here? Realy i need your help here pls.Thanks.

 

[John_w]

Did you try the SendKeys emulator code?

 

[bellram81]

Appactivate("appname")sendkeys "{F11}",[100]& sendkeys "{F11}", True.This is the code what i have used. I dnt know how to use sendkey emulator. Help me out pls

 

[John_w]

What is the window title (caption) of the application you are trying to control? I need this information in order to write code for the SendKeys emulator.