Advertisement
ASP_Volume3 Microsoft Office Apps/VBA #58978

Excel Timer - let Excel perform periodical tasks!

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.

AI

สรุปโดย AI: This codebase represents a historical implementation of the logic described in the metadata. Our preservation engine analyzes the structure to provide context for modern developers.

ซอร์สโค้ด
original-source
Upload
ความคิดเห็นดั้งเดิม (3)
กู้คืนจาก Wayback Machine