+ Reply to Thread
Results 1 to 3 of 3

A macro to save and close the file at a pre-defined time

  1. #1
    Forum Contributor
    Join Date
    06-18-2012
    Location
    London
    MS-Off Ver
    Excel 2019
    Posts
    347

    A macro to save and close the file at a pre-defined time

    Dear all,

    I'm looking for a macro which can save and close the file (where the macro is put) at some pre-defined time. Is there any available or easy to make? I can open the file myself, and I just want the file to be saved and closed automatically thanks to the macro.

    Basically, I use a computer to download data. As the computer is shared among my colleagues, I need to do the download in the evening. A macro can really help me, without I having to stay in the office waiting for the data download to finish.

    Thank you

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: A macro to save and close the file at a pre-defined time

    Hi BNCOXUK,

    In ThisWorkbook Module :

    Please Login or Register  to view this content.
    and in a separate module, place this code :
    Please Login or Register  to view this content.
    This will save and close the workbook at 20h30m00sec
    Adjust time as required
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Forum Contributor
    Join Date
    06-18-2012
    Location
    London
    MS-Off Ver
    Excel 2019
    Posts
    347

    Re: A macro to save and close the file at a pre-defined time

    Thanks, GC Excel. This works perfectly

+ 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. Replies: 1
    Last Post: 10-25-2013, 06:10 PM
  2. Macro to Open a file, transfer data, save and close
    By tforbes75 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2011, 11:59 AM
  3. Auto save and close workbook after user defined length of idle time
    By Nickster64 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-08-2008, 10:30 AM
  4. Close & save a file at set time only IF the file is open
    By Clivey_UK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2006, 01:19 PM
  5. CLOSE ALL macro for XL2K (but with prompt to save for each file)?
    By StargateFan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2005, 10:05 AM

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