98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Scheduling VBA Macros to Run
Scheduling VBA Macros to Run
Resolved · Medium Priority · Version 2016
Thu 6 Dec 2018, 11:49Delegate Jon said...
Jon has attended:
Excel VBA Introduction course
Excel VBA Intermediate course
Effective Communication Skills course
Power BI Modelling, Visualisation and Publishing course
Scheduling VBA Macros to Run
Hi,
Is there a way to schedule VBA code (currently held in Excel) to run daily at a set time?
Ideally I would not leave my computer on in order to run the code, so it should run at network level (as opposed to locally).
Many thanks,
Jon
Thu 6 Dec 2018, 13:06Trainer Jens said...
RE: Scheduling VBA Macros to Run
Hi Jon,
Thank you for the forum question.
VBA can only be executed from Excel and the file need to be open. If the code is stored in the template of Excel you do not need a special file to be open, but Excel need to be running.
The code:
Application.ontime timevalue("15:30:00"), "runmacro"
Will execute a macro called runmacro 15:30.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 6 Dec 2018, 14:04Delegate Jon said...
RE: Scheduling VBA Macros to Run
Thanks Jens,
Is there any way to make it work through the Windows Task Scheduler?
Thanks,
Jon
Fri 7 Dec 2018, 09:53Trainer Jens said...
RE: Scheduling VBA Macros to Run
Hi Jon,
Unfortunately I have no knowledge of the Windows Task Scheduler, but I found the link below, which can help you in the right direction.
https://stackoverflow.com/questions/22771185/how-to-set-recurring-schedule-for-xlsm-file-using-windows-task-scheduler
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Fri 14 Dec 2018: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Selecting your working rangeIn excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range. |
