+ Reply to Thread
Results 1 to 2 of 2

Recurring Macro using Application.OnTime

  1. #1
    Registered User
    Join Date
    01-29-2008
    Posts
    1

    Recurring Macro using Application.OnTime

    Hi, I'm a bit of an intermediate with Excel and a complete novice with VBA. I'm trying to write some code to make a macro run regularly at time intervals and I have written the following code:

    Please Login or Register  to view this content.
    I sent this to a friend who has tried the code on their PC and it is working. I have copied the references set up on his version of Excel but the code still refuses to work on my PC.

    The code is correct and the references are correct. Does anyone have any idea what I could have missed?
    Last edited by Leith Ross; 01-29-2008 at 01:42 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello WhitChurch123,

    Welcome to the Forum!

    The macro being called must be passed as a String Type. Change this line of your code...

    From
    Please Login or Register  to view this content.
    To
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

+ 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