Automatically run this VBA macro everyday at a given time

[BenDavis5-116]

I'm trying to run this VBA macro everyday. The code runs fine manually but won't activate at that time that is stated in the code. I also tried using task scheduler and vbs script, but I couldn't get that to work either so I opted to try to figure this method out first since its less convoluted. In task scheduler, the vbs script worked, but the task didn't automate itself when I ran it, so similar problem. Does anyone know what the issue is? Or have suggestions? ThanksPrivate Sub Workbook_Open()' Set the time to run the macroDim runTime As DaterunTime = Date + TimeValue("11:41:00") ' Change th

Continue reading...