Excel Timer - let Excel perform periodical tasks!
Posted: 2002-06-01
By: ArchiveBot
Viewed: 69
Filed Under:
Title | Uploaded | Size |
---|---|---|
Excel_Time78891532002.zip | 9/3/2020 3:45:00 PM | 19,133 |
A friend of mine asked me about how to let excel periodically update
some worksheets containing stock prices. So the first thing I did was
searching the web for a solution in Visual Basic for Applications.
But the only one I found was to use a 3rd party ActiveX timer control
which you have to place onto a userform. Then I found the VBA command
"Application.onTime" and I had an idea.
Here is my solution only utilizing the VBA onTime command. NO need for
ActiveX control or any other 3rd party module.
Original Author: Sebastian Thomschke
Comments on this post
No comments have been added for this post.
You must be logged in to make a comment.