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

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




:)

 

Excel spreadsheet with macro opens blank.


Dell Latitude E5500 laptop
Windows 10 Professional
Microsoft Excel Office XP Standard with 2007 Conversion

I have created a spreadsheet that opened normally until I added a "Clear Contents" control & macro. Now when I attempt to open the file, it opens with a blank screen. Within that blank screen I can Open the spreadsheet. My Dell 660 PC with Windows 10 Home and the same Excel software works fine on that spreadsheet. Any help will be much appreciated.

 

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?

 

Error on opening task scheduler

Thanks for your prompt reply.

I have tried Method 1 and had no luck. The error still appears when opening Task Scheduler and again when I click Refresh.

Method 2 seems to have step 3 missing as I don't know what code I am looking for in step 4 or where to look for it in the Task Scheduler window.

I will await further instruction.

Thanks again.