Emerogork 0 Posted April 27, 2014 (edited) I wish to schedule an hourly refresh of Excel from the Windows 7 Task Scheduler. Suggestions? Edited April 27, 2014 by Emerogork Share this post Link to post Share on other sites
l3ill 70 Posted April 27, 2014 Depends on what you want to refresh... data connections are updated with CTRL + ALT + F5 for instance. My Contributions...SnippetBrowserNewSciTEPathFinderText File ManipulationFTP Connection Tester / INI File - Read, Write, Save & Load Example Share this post Link to post Share on other sites
l3ill 70 Posted April 27, 2014 BTW you can also use the connection properties to refresh every 60 seconds. My Contributions...SnippetBrowserNewSciTEPathFinderText File ManipulationFTP Connection Tester / INI File - Read, Write, Save & Load Example Share this post Link to post Share on other sites
Emerogork 0 Posted April 27, 2014 (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 April 27, 2014 by Emerogork Share this post Link to post Share on other sites
l3ill 70 Posted April 27, 2014 Have a look at ControlSend to interact with an excel window. My Contributions...SnippetBrowserNewSciTEPathFinderText File ManipulationFTP Connection Tester / INI File - Read, Write, Save & Load Example Share this post Link to post Share on other sites
Emerogork 0 Posted April 27, 2014 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"? Share this post Link to post Share on other sites
Emerogork 0 Posted April 28, 2014 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