Results 1 to 3 of 3

OnTime event to automate my excel sheet

Threaded View

  1. #1
    Registered User
    Join Date
    05-16-2014
    Location
    London, England
    MS-Off Ver
    Office 2013
    Posts
    9

    OnTime event to automate my excel sheet

    Hi,

    I'm stuck working out how to automate my excel sheet i have got.

    It has code which when you click the "Save" button it saves the document and then converts a copy as CSV with the same name.

    I have been trying to automate this to run every 2 minutes but everything i have tried does not work.

    I have tried using OnTime events but again does not work.

    Could someone point me in the right direction or help me with automating this workbook?

    Thanks in advance.

    Andrew
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Some questions concerning the .OnTime event in Excel
    By Bezzie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-13-2013, 01:54 AM
  2. [SOLVED] Trouble stopping an Application.OnTime event
    By phuz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2012, 09:34 AM
  3. Using OnTime to schedule an event, error at the scheduled time
    By 6StringJazzer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2010, 10:40 AM
  4. Use Event Procedure and OnTime to Stop a Macro
    By Protiusmime in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-26-2008, 07:46 PM
  5. Workbook_BeforeClose event and OnTime method
    By Bejaz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2005, 11: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