Sign in to follow this  
Followers 0
MythBusted

Excel Keystroke Sequence

2 posts in this topic

Hi folks,

I've just started using AutoIT v3. I've spent the last week or so developing an Excel script using AutoIT. Why not create an Excel macro, you ask? Well, I need to tie this script in to other future AutoIT scripts, since I'm developing one big app which accesses three other programs, aside from Excel, and I'd rather use the same IDE for all if them.

Well, back to my question. I've tried to send a CTRL-SHIFT-END (selects all cells from the active cell until the end of the worksheet) command to Excel, but it doesn't seem to like that sequence. My Send command looks like:

Send("^{SHIFTDOWN}{END}{SHIFTUP}{ENTER}")

When I send a CTRL-END command, it works fine. It doesn't like the SHIFT part. Am I doing something wrong, or could this be a possible bug?

Thanks so much for your assistance!

Share this post


Link to post
Share on other sites



Try this:

Send("^+{END}")

Also search Scripts & Scraps for the ExcelCOM UDF.


[font="Tahoma"]"Tougher than the toughies and smarter than the smarties"[/font]

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0