Automatically run this VBA macro everyday at a given time

  • Thread starter Thread starter BenDavis5-116
  • Start date Start date
B

BenDavis5-116

Guest
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...
 
You must log in or register to reply here.

Similar threads

B
Automatically run this VBA macro everyday at a given time
Replies
0
Views
5
BenDavis5-116
B
B
Task scheduler is running task, but not activating the VBA code in the spreadsheet.
Replies
0
Views
14
BenDavis5-116
B
B
Task scheduler is running task, but not activating the VBA code in the spreadsheet.
Replies
0
Views
3
BenDavis5-116
B
A
Why do I get this .NET Framework unhandled exception for a value not found in the expected range error?
Replies
0
Views
7
Alex Lagarde2
A
A
Why do I get this .NET Framework unhandled exception for a value not found in the expected range error?
Replies
0
Views
9
Alex Lagarde2
A
Back
Top