Windows 10 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

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...
 
Back
Top