Sign in to follow this  
Followers 0
Emerogork

How do I send an "F9" into Excel?

7 posts in this topic

#1 ·  Posted (edited)

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



#4 ·  Posted (edited)

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

Depends on what you want to refresh...

data connections are updated with CTRL + ALT + F5 for instance.

 

BTW you can also use the connection properties to refresh every 60 seconds.

attachicon.gifcapture_27042014_211825.jpg

 

Where do I find said "Connection Property"?

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  
Followers 0