Closed Thread
Results 1 to 2 of 2

Can you create a programme that automatically runs a macro for you at set time intervals?

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

    Can you create a programme that automatically runs a macro for you at set time intervals?

    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

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Can you create a programme that automatically runs a macro for you at set time interva

    I don't see the reason that you ignored Admin's suggestion to read forum rules in your other thread...Pls do it!

    In the meantime..

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] My programme only runs how it should on my computer
    By Imperial in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2013, 06:06 AM
  2. Converting Data in Irregular Time Intervals into Regular Time Intervals
    By AlexJT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2011, 02:42 AM
  3. Need to Transpose Irregular Time Intervals into Regular Time Intervals
    By AlexJT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2011, 08:30 PM
  4. Macro automatically runs report
    By yes sir in forum Access Tables & Databases
    Replies: 9
    Last Post: 08-26-2010, 04:15 PM
  5. Macro that runs automatically?
    By Johann in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2006, 09:20 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