Having a macro run automatically every 15 minutes
Posted by Matt on June 11, 2001 9:05 AM
I have a somewhat workable block of code below, but am certain that there is a better way of writing this. I would like to open my workbook, click on my macro button (currently assigned to the below AutoUpdate macro) and then have it run in the background and call another subroutine automatically every 15 minutes. Any suggestions? Thanks!
Application.Wait (Now + TimeValue("00:15:00"))