Emerogork Posted April 27, 2014 Share 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 Link to comment Share on other sites More sharing options...
l3ill Posted April 27, 2014 Share Posted April 27, 2014 Depends on what you want to refresh... data connections are updated with CTRL + ALT + F5 for instance. My Contributions... SnippetBrowser NewSciTE PathFinder Text File Manipulation FTP Connection Tester / INI File - Read, Write, Save & Load Example Link to comment Share on other sites More sharing options...
l3ill Posted April 27, 2014 Share Posted April 27, 2014 BTW you can also use the connection properties to refresh every 60 seconds. My Contributions... SnippetBrowser NewSciTE PathFinder Text File Manipulation FTP Connection Tester / INI File - Read, Write, Save & Load Example Link to comment Share on other sites More sharing options...
Emerogork Posted April 27, 2014 Author Share 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 Link to comment Share on other sites More sharing options...
l3ill Posted April 27, 2014 Share Posted April 27, 2014 Have a look at ControlSend to interact with an excel window. My Contributions... SnippetBrowser NewSciTE PathFinder Text File Manipulation FTP Connection Tester / INI File - Read, Write, Save & Load Example Link to comment Share on other sites More sharing options...
Emerogork Posted April 27, 2014 Author Share 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"? Link to comment Share on other sites More sharing options...
Emerogork Posted April 28, 2014 Author Share 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... (-: Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now