Dear members of the forum,
is it possible to start a macro every 24 hours?
I would like to make a dynamic dashboard and therefor I need to refresh the data once a day.
How can I program something like this?
I have the macro already, I just need to autostart it every day.
Sorry I'm quite new to VBA/macros, but thank you for your help in advance,
Best regards,
David
I do not know how other people solve this, I done this as below.
- Create VBS file like below:
edit red according to your path and names
Please Login or Register to view this content.
- set in windows Task Scheduler that this VBS file have to be run every 24 hours.
And that's all. Works for me.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
The following macro is used to 'auto save' the workbook each day at 10 seconds past midnight.
The time can be changed for your purposes ... save 9:30 am ? by editing the time value :
Application.OnTime TimeValue("09:30:00"), "sveWrkBk"
Change 'sveWrkBk' to the name of your refresh macro and include your refresh macro separate fromPlease Login or Register to view this content.
this macro.
Look at the attached workbook in the ThisWorkbook module and you will find the following macro that auto
runs the sveWrkBk macro when the workbook is first opened for the day ...
Please Login or Register to view this content.
Re: Start Macros every 24 hours
Originally Posted by mrdaave
Why not just 'autostart' it at the workbook opening ?
Thank you very much for your help!
I was able to solve the problem with your inputs
@Marc L: The problem is that I dont want to start the macro every time I open the workbook (its permanently open), but just to start it every day (at e.g. 12 o'clock)
Glad you have an answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks