Task scheduler is running task, but not activating the VBA code in the spreadsheet.

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

BenDavis5-116

Guest
I have a VBA code in an excel spreadsheet that is written to save data everyday and create a seperate spreadsheet of said data. The task scheduler is used run this program, at a specific time of my choice. Right now, when I run the task, it opens up excel but the actual code embedded in the file does not activate. I've looked through the conditions and triggers and messed around with them but haven't made any progress. Also, I'm not getting any error messages, it just isn't creating the output that it should. When I run the task, the app logo for excel flashes orange. I don't know what that me

Continue reading...
 
You must log in or register to reply here.

Similar threads

B
Task scheduler is running task, but not activating the VBA code in the spreadsheet.
Replies
0
Views
3
BenDavis5-116
B
J
task scheduler return code 0xc0000135 (Not .NET)
Replies
0
Views
7
JimS0313
J
B
Run a program by the .bat file but not show icon and window of the program when PC is log off and it call by Task Scheduler
Replies
0
Views
23
Balazs .
B
B
Run a program by the .bat file but not show icon and window of the program when PC is log off and it call by Task Scheduler
Replies
0
Views
5
Balazs .
B
V
Windows Server 2016: Task Scheduler "Launch task ... same task is already running"
Replies
0
Views
10
vzmon1
V
Back
Top