× Welcome to the fracta.net forum!

Share your coding ideas or ask questions.

Auto Run Script for CMS in Exce

More
3 years 4 months ago #647 by mahmod
Dear Roller,

i want Excel to Auto Refresh / Run every 30 minutes for my script.. can suggest how to do it?

This file will be displayed @ wall board for CSR to know current performance center every 30 min.

Please Log in or Create an account to join the conversation.

More
3 years 4 months ago #648 by roller
You can use the VBA OnTime to run your procedure every interval

Sub main
Application.OnTime Now + TimeValue("00:30:00"), "my_Procedure"
End Sub

You run sub main and it will run the my_procedure sub every 30 minutes

Please Log in or Create an account to join the conversation.

Time to create page: 0.157 seconds
Powered by Kunena Forum