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

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

:)

 

Task scheduler not completing task

After upgrading recently to Windows 10, certain tasks stopped working. I decided to create the tasks all over again.

The way these tasks work is to open an Excel spreadsheet at a certain time in the early morning.

There is VBA code macro set to run on opening. It accesses information from an SQL Server database, sends it out as an email, and then closes itself. It used to work fine before the upgrade to 10.

I've tried a lot of different things to get it to work: I am creating the task from the Owner account, which is an administrator. I have tried opening the Task Scheduler "as administrator." (The spreadsheet to be opened is also located in a directory of
the Owner account, from a trusted location.) I've tried running the task "with highest privileges."

The problem is not the spreadsheet or the VBA code. I am able to run the code and send out the emails by "manually" opening the spreadsheet. It is just that the task won't open it.

The task history shows the following as the last three entries: "Created Task Process", "Task Started", and finally "Action Started."

However, the spreadsheet doesn't seem to be opening.

Any ideas?

 

Window's Task Scheduler Not Running

Hi,

To assist you better, kindly provide us more details by answering the following questions:

• Have you tried recreating the task? If so, are you getting the same issue?
• Have you tried creating a new task?

Meanwhile, we suggest that you ensure that the Task Scheduler is running. You can verify if the service is running by following these steps:

• Press Windows key + R on your keyboard.
• Type services.msc and hit Enter.
• Under Services (Local), make sure that the Task Scheduler service's status is
  Started or Enabled.

Should you need further assistance, feel free to get back to us.

 

Task Scheduler Utility

Anything you can run manually can be run from Task scheduler.

I do suggest that you check which power states your computer has because S0 Modern standby [aka S0 Low power idle] inhibits Task scheduler significantly.
Code:

If you have S0 then Task scheduler cannot run anything while in S0 i.e. while your display is off.

Denis