+ Reply to Thread
Results 1 to 5 of 5

Application.Ontime on specific days?

  1. #1
    Registered User
    Join Date
    08-20-2015
    Location
    Bedford
    MS-Off Ver
    2010
    Posts
    12

    Application.Ontime on specific days?

    Hey guys, so I have the below
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    I am looking to set the application.Ontime to only run on a Friday (so that it changes the picture at the end of each week), is there an easy way of doing this?
    Last edited by Flammabubble; 08-25-2015 at 07:53 AM.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Application.Ontime on specific days?

    Hi Flammabubble,

    I hope you realize that the Workbook must be open at all times for your code to work.

    Try the following:
    Please Login or Register  to view this content.

    You also need the following code in the ThisWorkbook module to cancel the schedule when the workbook closes and Excel is still open.
    Please Login or Register  to view this content.
    Lewis

  3. #3
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Application.Ontime on specific days?

    Hi,
    as an option you can use
    http://windows.microsoft.com/en-au/w...#1TC=windows-7
    it opens excel, yr code is running and perhaps is what you are looking for.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  4. #4
    Registered User
    Join Date
    08-20-2015
    Location
    Bedford
    MS-Off Ver
    2010
    Posts
    12

    Re: Application.Ontime on specific days?

    Thank you very much for your response! I am aware that the workbook needs to be open with this, that's fine.

    The one issue I have with this is I was planning to have multiple pictures changing over a number of weeks (e.g. this friday picture 1, next friday picture 2, then picture 3 then back to picture 1. As far as I can see what you have given will change it for the next coming friday and then stop. Do you have any suggestions so that it repeats and then goes back to the first setting?

  5. #5
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Application.Ontime on specific days?

    Hi,

    Try this. I tested it the best that I could without having to wait several weeks for results. Each time the file is opened, the first picture is displayed.

    To customize for your picture names, add or delete names in the line in red below. The first name in the list is NEVER used, but MUST be there as a place holder.

    Please Login or Register  to view this content.
    Lewis

+ 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. Application.OnTime Help
    By bs04do in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-05-2013, 09:06 AM
  2. application.ontime
    By msolari in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2013, 05:24 AM
  3. [SOLVED] Help with Application.OnTime (was Application.Wait Now)
    By Walter12 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-29-2012, 01:18 PM
  4. use of Application.ontime
    By katto01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2012, 09:58 PM
  5. Application OnTime
    By albatross32 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2011, 07:40 AM
  6. Application.OnTime
    By sportsguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2008, 02:09 PM
  7. Help with Application.OnTime
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2006, 01:10 PM
  8. application.ontime
    By rick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2005, 02:05 PM

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