Consulting

Results 1 to 4 of 4

Thread: Application.ontime

  1. 02-20-2008, 12:36 PM #1
    philfer
    philfer is offline
    VBAX Tutor
    Joined
    Nov 2007
    Posts
    291
    Location

    Application.ontime

    Hello,

    Is there a way to get around using Application.Ontime with a workbook that isnt open?

    Thanks
    Reply With Quote Reply With Quote
  2. 02-20-2008, 12:40 PM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    What are you trying to do?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  3. 02-20-2008, 12:58 PM #3
    philfer
    philfer is offline
    VBAX Tutor
    Joined
    Nov 2007
    Posts
    291
    Location
    I'm trying to run a macro at a certain time during the night/day but without it needing to be open i.e. it will work behind the scenes
    Reply With Quote Reply With Quote
  4. 02-20-2008, 03:12 PM #4
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    If you fire off an Ontime and then close the workbook, as long as Excel is still running, it will automatically open it.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules