Windows 10: Refreshing Excel SpreadSheet by runnig script using Task Scheduler

I have the code below. It worked on my old windows machine but now the code does not work for my Windows 10 machine. Thoughts? Here is the code and message I get. It asks me how do I want to open the file (picture below). Also, can I store this file on OneDrive and update in daily by using the Task Scheduler?


Dim oExcel

Set oExcel = CreateObject("Excel.Application")



oExcel.Visible = True

oExcel.DisplayAlerts = False

oExcel.AskToUpdateLinks = False

oExcel.AlertBeforeOverwriting = False





Set oWorkbook = oExcel.Workbooks.Open("L:\Location\Test.xlsx")

oWorkbook.RefreshAll

oWorkbook.Save



oExcel.Quit

Set oWorkbook = Nothing

Set oExcel = Nothing







***Original title: Task Scheduler Windows 10 - Refreshing an Excel Spreadsheet daily on open***

:)

 

Running a VB Script File Using Windows 10 Task Scheduler

Please post your current version of the script.

Note also that I'll be off the air for a whole week, starting this coming Sunday evening. With your response cycle of one reply per day, you are unlikely to solve your problem anytime soon. This is aggravated by you consistenly posting insufficient information
(e.g. repeatedly not posting your script, not posting numbers of problem lines, taking numerous attempts to post the exported xml file etc. etc.). You need to remember that respondents cannot see your screen.

Lastly - you are trying to use the Task Scheduler to launch a script to open an Excel file to launch a macro. This is an extremely ambitious task. It is also not a good way to do things. A script can do everything that a macro can, and more, but more simply.
Forget about the macro. Here are the steps you should take:

• Get my script going in the foreground.
• Get it going while scheduled.
• Write a script that opens an Excel file.
• Run it in the foreground.
• Run it in the background.
• Expand it to manipulate the spreadsheet.
• Run it in the foreground
• Run it in the background.

 

Task Scheduler doesn't run script

Hi,

Thank you for writing to Microsoft Community Forums.

Are you able to run the script manually? If yes, does it do what it is intended to?

Disable the UAC temporarily.

Make sure that the Task scheduler
service is running.

Press ‘Win+R’.

Type Services.msc.

Locate the service Task scheduler
and make sure that it is in running state.

Go to the Conditions
tab in task scheduler and make sure that no such condition is set which could block the task from running.

Enable All Tasks History in Task scheduler and run the scheduled task.

Refresh the task scheduler and check if you find any error message/code for any step in the task run.

Also try with disabling Run whether the user is logged on or not
option and see if the script runs.

Hope it helps.

Peer Samie

Microsoft Community-Moderator

 

Task Scheduler Error


When I access Task Scheduler, an error appears that says SqmUpload_S-1-5-21......... no longer exists. To see the current tasks, click Refresh. However, the same message appears when I click Refresh. I can close the message and it appears the Task Scheduler is OK. A person on the Microsoft boards gave me several steps to follow beginning with booting into Safe Mode. However, I received a message when I accessed Task Scheduler that it doesn't function in Safe Mode.
I did not feel safe following their additional suggestions at that point as I am not that adept at such endeavors. Has anyone else encountered this error and/or found a simple solution? I feel it is caused by some remnant leftover from Windows 7 during the upgrade but this is pure conjecture on my behalf.