Mimic keystrokes?

T

Targus

Hi,

Does anyone know how to mimic keystrokes and/or mouse movements using
VBA??

I'm writing a macro that uses a macro written by someone else. I do
not have access to their code, so I can't see what is happening on
their end. When their code is run, a file path box opens twice, and
each time a user has to manually press the 'cancel' button on the file
path box. I want to have my VBA code press the 'cancel' button or
press the 'escape' key twice to mimic a user clicking a mouse or
pressing 'escape' to ignore the file path box.

Any suggestions ??
 
R

RB Smissaert

You could try any of these 2 lines, but the result will be totally
unpredictable.

SendKeys "{ESC},2", True
SendKeys "{ESC},2", False

RBS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top