Jump to content
Sign in to follow this  
Emerogork

How do I send an "F9" into Excel?

Recommended Posts

I wish to schedule an hourly refresh of Excel from the Windows 7 Task Scheduler.

Suggestions?

Edited by Emerogork

Share this post


Link to post
Share on other sites

I have a visual effect that is based on the present hour of time.  When I press F9 the effect updates.  Now I want to schedule that F9 to occur at 5 minutes after the hour and to do it as triggered from the Task Scheduler.

So, I wish to send an F9 to a specific Excel spread sheet. For this, the spread sheet will be open but for future thought, how might I send an F9 to a spread sheet that is not presently open.  Suppose I am collecting temperatures into sequential cells.  The F9 will update the spread sheet as programmed.  Don't be concerned how I am going to deal with the data, just let me know how to send an F9 into Excel to refresh.

Other methods will be considered.

Edited by Emerogork

Share this post


Link to post
Share on other sites

Have a look at ControlSend to interact with an excel window.

 

I guess that "ControlSend" is a feature of AutoIt but I don;t see where/how to look into it.  I am beginning to believe that I may not have a full set up here.   More ways than one... (-:

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  

×
×
  • Create New...