+ Reply to Thread
Results 1 to 4 of 4

Macro to close excel file at specific time

  1. #1
    Forum Contributor
    Join Date
    07-30-2014
    Location
    Mosman, Australia
    MS-Off Ver
    2013
    Posts
    118

    Macro to close excel file at specific time

    Hi there,

    I need a macro to automatically close excel file after 7pm daily. I can't use "Task Manager" as the computer is my work PC and this application is disabled by IT, therefore, I need a macro to close the excel file when left open.

    Thanks

  2. #2
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Macro to close excel file at specific time

    Same question as

    http://www.excelforum.com/excel-prog...me-of-day.html
    Last edited by WasWodge; 09-15-2016 at 02:17 AM.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

  3. #3
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Macro to close excel file at specific time

    tsk, tsk

    And the first question was posted 6:31 today and he got an answer at 7:12.

    But what I find more interesting is that of the 63 questions he has posted only one is marked "Solved", so either he has been very unlucky as he has got no solutions to his problems or he is not aware that if a solution is given one should mark thread solved.

    Alf

    To mark your thread solved do the following:
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

  4. #4
    Forum Contributor
    Join Date
    07-30-2014
    Location
    Mosman, Australia
    MS-Off Ver
    2013
    Posts
    118

    Re: Macro to close excel file at specific time

    Shut up Alf, i don't care.

+ 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. Macro to Close Excel Program at specific time of day
    By Cremorneguy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2016, 08:36 AM
  2. [SOLVED] Macro to open Excel file, run other macros save, and close file & repeat.
    By Ronnet2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2015, 09:47 AM
  3. Macro to close and re-open a workbook at specific time
    By hasanqz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2015, 03:38 PM
  4. [SOLVED] A macro to save and close the file at a pre-defined time
    By BNCOXUK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2013, 01:34 AM
  5. Replies: 0
    Last Post: 10-02-2013, 01:47 AM
  6. Auto close excel (2010) at specific time bypassing data validation
    By vstrom22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2012, 11:53 AM
  7. Macro for close of excel file on sharepoint
    By DKY in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2010, 06:41 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