+ Reply to Thread
Results 1 to 2 of 2

Need help with automating a macro to run overnight every week.

  1. #1
    Registered User
    Join Date
    11-25-2020
    Location
    UK
    MS-Off Ver
    WINDOWS 10
    Posts
    1

    Need help with automating a macro to run overnight every week.

    Hello,

    First post and very new to VBAs.

    I have several work sheets where there is data tab that needs refreshing every week. Later in the week I review and make changes. I've got a macro that automates the data refresh for me.

    I'd like to automate the whole process so it runs over night Sunday to Monday so every time I open the sheet it's already up to date for me and refreshed the data.

    What would be the best way to do this?

    Thank you,

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,849

    Re: Need help with automating a macro to run overnight every week.

    Hi, welcome to the forum.
    If the file is already working and you have a macro that updates and closes the file you can use the Windows Scheduler to carry this out.
    The folder and file needs to be accessible or if on a server triggered by a server account.
    You can the have Excel open and execute that macro which will do the job for you.
    Hope it makes sense.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automating 'Week/Month/Year to Date' Calculation
    By dhruvb in forum Excel General
    Replies: 1
    Last Post: 07-16-2020, 05:24 PM
  2. Macro that will work on different sheets week to week?
    By samanthamag in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-01-2017, 10:47 AM
  3. [SOLVED] Overnight Macro/VBA button not working.
    By llamafarmer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2014, 05:25 AM
  4. [SOLVED] Macro that displays all the weeks between Start Week and End Week (ends in next year)
    By Tona in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-31-2014, 05:38 AM
  5. Overnight Time Graph help!!
    By kp0712 in forum Excel General
    Replies: 3
    Last Post: 02-27-2014, 01:46 PM
  6. Keep macro running overnight?
    By JeffMelton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2006, 03:50 PM
  7. [SOLVED] How do you run an excel macro automatically overnight?
    By Scott J in forum Excel General
    Replies: 1
    Last Post: 01-06-2006, 02:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1