+ Reply to Thread
Results 1 to 3 of 3

Is This possible on excel and if so how?

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    London,England
    MS-Off Ver
    Excel 2010
    Posts
    25

    Is This possible on excel and if so how?

    Hi all,

    I have an excel document that sends information to some large display boards.

    The document is meant to update every hour but it randomly stops updating.

    To update the boards manually there are three buttons that you click in the order 1,2,3.

    Is there a way that I can get the programme to automatically click the buttons in the order (1) (2) (3)
    with a time delay between I.e. Press button 1. Wait 60 seconds Press button 2. Wait 60 seconds. Press button 3. And then repeat every 60 minutes?

    OR

    Can anyone think of what may be the problem thats making the programmes automatic renewal crash in the first place?



    Any help would be much appreciated and my skills are very basic so please provide as much detail as possible!

    Thanks in Advance.

    Matt
    Attached Images Attached Images

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,342

    Re: Is This possible on excel and if so how?

    Great picture. Useless for diagnosing the problem.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Is This possible on excel and if so how?

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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