How do I send an "F9" into Excel?

[Emerogork]

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

Suggestions?

Edited April 27, 2014 by Emerogork

[l3ill]

Depends on what you want to refresh...

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

[l3ill]

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

[Emerogork]

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 April 27, 2014 by Emerogork

[l3ill]

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

[Emerogork]

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.

capture_27042014_211825.jpg

 

Where do I find said "Connection Property"?

[Emerogork]

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... (-: