Welcome to the fracta.net forum!

Share your coding ideas or ask questions.

Question Auto Run Script for CMS in Exce

  • mahmod
  • Topic Author
  • Visitor
  • Visitor
6 years 9 months ago #647 by mahmod
Auto Run Script for CMS in Exce was created 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
6 years 9 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.752 seconds
Powered by Kunena Forum