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

Discus and support Refreshing Excel SpreadSheet by runnig script using Task Scheduler in Windows 10 Customization to solve the problem; 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... Discussion in 'Windows 10 Customization' started by Kritter0021, Mar 19, 2019.

  1. 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


    Refreshing Excel SpreadSheet by runnig script using Task Scheduler 5b4ca06e-f2e7-4ec2-b719-136bfb44389b?upload=true.png




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

    :)
     
    Kritter0021, Mar 19, 2019
    #1

  2. 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.
     
    Frederik Long, Mar 19, 2019
    #2
  3. Peer_Sam Win User
    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
     
    Peer_Sam, Mar 19, 2019
    #3
  4. HokieMan Win User

    Refreshing Excel SpreadSheet by runnig script using Task Scheduler

    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.
     
    HokieMan, Mar 19, 2019
    #4
Thema:

Refreshing Excel SpreadSheet by runnig script using Task Scheduler

Loading...
  1. Refreshing Excel SpreadSheet by runnig script using Task Scheduler - Similar Threads - Refreshing Excel SpreadSheet

  2. Excel will not use Thunderbird to email spreadsheet on Windows 10 Pro

    in Windows 10 Software and Apps
    Excel will not use Thunderbird to email spreadsheet on Windows 10 Pro: My lady friend wants an idiot proof system (if there is such a thing), one aspect of which is to email an Excel sprreadsheet to a group of fundraising friends. From my own PC running Win 7 I can do this by the 'usual' method of Alt+F+d and it will email using Thunderbird. On...
  3. Task Scheduler Windows 10 - Refreshing an Excel Spreadsheet daily on open

    in Windows 10 Customization
    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...
  4. Excel Spreadsheet

    in Windows 10 BSOD Crashes and Debugging
    Excel Spreadsheet: A simple xlsm spreadsheet suddenly stopped loading. Clicking on the icon to load, and alternatively clicking on the file itself, the green EXCEL screen shows, It asks to update links, answer as previously is Dont update, then the screen remains blank and nothing happens....
  5. Excel spreadsheets open blank.

    in Microsoft Office and 365
    Excel spreadsheets open blank.: Recently my Excel programs began to open with a blank Excel screen. I can go to Open in the blank sheet and open the spreadsheet from there. This happening on my Dell Latitude E5500 Laptop. This has been working fine for years. My PC is opening my Excel spreadsheets...
  6. Task Scheduler doesn't run script

    in Windows 10 Software and Apps
    Task Scheduler doesn't run script: Hey Microsoft Community, I'm trying to create a task in Task Scheduler that runs a specific script. The issue is that when the task runs (whether I do it manually or if it's scheduled), the script doesn't actually get executed. I know that the script works, and I have tried...
  7. BSOD Usually happens when using Excel spreadsheet.

    in Windows 10 BSOD Crashes and Debugging
    BSOD Usually happens when using Excel spreadsheet.: Hello, I've been experiencing BSOD over the past month. Just ignored as it was random but i've now realised that it's usually happening when I'm using Excel. I have attached the dump files following the instructions on the forum. I've tried to use the debugging tool...
  8. Problem Getting a Powershell Script to Run in Task Scheduler

    in Windows 10 Software and Apps
    Problem Getting a Powershell Script to Run in Task Scheduler: Hope I'm in the right place! I am trying to get a Powershell script to run daily in the task scheduler. It basically purges a folder on one of my drives: Get-ChildItem –Path “D:\Dropbox\Quicken\Backup” –Recurse | Where-Object CreationTime –lt (Get-Date).AddDays(-10) |...
  9. Task Scheduler Script

    in Windows 10 Network and Sharing
    Task Scheduler Script: I want to enable and disable my Ethernet connection at specific times each day. Task Scheduler prompts me for the script identifying the action of enabling or disabling the Ethernet connection. How do I identify these two specific scripts? 75194
  10. What script do I use in Task Scheduler to delay/minimize on startup?

    in Windows 10 Support
    What script do I use in Task Scheduler to delay/minimize on startup?: I am creating a task in the task scheduler to delay the startup of OneDrive for 5 minutes and it is working but when it launches it is opening a window instead of minimizing or running in background. I am using "\minimize" as argument but it's not working. What do I use...

Users found this page by searching for:

  1. task scheduler refresh excel sheet

    ,
  2. using task scheduler to update excel spreadsheet with CRM data

    ,
  3. task scheduler refresh an excel file