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

Discus and support Task Scheduler Windows 10 - Refreshing an Excel Spreadsheet daily on open 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 18, 2019.

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


    Task Scheduler Windows 10 - Refreshing an Excel Spreadsheet daily on open 5b4ca06e-f2e7-4ec2-b719-136bfb44389b?upload=true.png

    :)
     
    Kritter0021, Mar 18, 2019
    #1
  2. theweav Win User

    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.
     
    theweav, Mar 18, 2019
    #2
  3. SKeithLA Win User
    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?
     
    SKeithLA, Mar 18, 2019
    #3
  4. Task Scheduler Windows 10 - Refreshing an Excel Spreadsheet daily on open

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

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

Loading...
  1. Task Scheduler Windows 10 - Refreshing an Excel Spreadsheet daily on open - Similar Threads - Task Scheduler Refreshing

  2. Windows 10 Task Scheduler

    in Windows 10 Customization
    Windows 10 Task Scheduler: Whenever we create an yearly/monthly job thru Task Scheduler, we need to set the start date of the job, prior to the current year/month Trigger date irrespective of Implementation date of the new job. For Eg. Implementation date of the new job : Jan 17 2020 the day...
  3. 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...
  4. Windows Task Scheduler

    in Windows 10 Ask Insider
    Windows Task Scheduler: I'm trying to set up a task on the task scheduler to run one or two other applications when one application is started. I want to be able to open one app and have the rest auto run instead of manually opening each one. I tried to set up the task to run at an event (startup of...
  5. How to open an Excel spreadsheet protected by bitlocker on a different PC.

    in AntiVirus, Firewalls and System Security
    How to open an Excel spreadsheet protected by bitlocker on a different PC.: I created an Excel spreadsheet on a W10 Pro SSD drive that is protected by bitlocker. I then copied it onto a USB drive (not protected by bitlocker) and when I try to open it on a different W10 Pro PC, I get Error 0x80071771: The specified file could not be decrypted. I...
  6. Refreshing Excel SpreadSheet by runnig script using Task Scheduler

    in Windows 10 Customization
    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...
  7. 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....
  8. Can't open some excel spreadsheets

    in Windows 10 BSOD Crashes and Debugging
    Can't open some excel spreadsheets: I have Windows 10 and I recently installed Publisher onto my computer now I cannot open some spreadsheets. I don't get any type of error message they just won't open....
  9. 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...
  10. Errors by opening Task Scheduler

    in Windows 10 Software and Apps
    Errors by opening Task Scheduler: Hello. When I open the Task Scheduler, I get many error messages, which mostly resemble to "Task Name: The task object version is either unsupported or invalid" along with a few "The selected task 'Name' no longer exists. To see current task, click Refresh". One thing...

Users found this page by searching for:

  1. task scheduler refresh excel sheet

    ,
  2. scheduled refresh excel in ONEDRIVE

    ,
  3. microsoft scheduler run refresh script in ONEDRIVE

    ,
  4. windows 10 open excel spreadsheet every week,
  5. task scheduler open excel,
  6. excel vba running on task scheduler wont stop running until I log in remotely,
  7. windows 10 task scheduler to open a excel worksheet,
  8. task scheduler wont open excel windows 10,
  9. open excel speadsheet with windows 10 scheduler,
  10. task scheduler refresh an excel file,
  11. task scheduler open onedrive excel and update