+ Reply to Thread
Results 1 to 2 of 2

Open an Excel file at a specific time

Hybrid View

  1. #1
    Registered User
    Join Date
    08-24-2007
    Posts
    16

    Open an Excel file at a specific time

    I was wondering if there is a way to have a file open automatically at a specific time each day, say 3PM Monday to Friday. I assume it would be code that would always run in the background if Excel is open and if Excel were closed it would not run. Anybody have any insights on this? Thanks

  2. #2
    Registered User
    Join Date
    12-08-2011
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Open an Excel file at a specific time

    The Application.wait is the thing you want to do.

    For example:
    Application.Wait "00:00:00"
    Where "00:00:00" is the place for the time of the day. So for 3PM you'd have: "15:00:00"

    You could also just go off of seconds and what not, from the time you open the sheet. Let me know if that helps...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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