+ Reply to Thread
Results 1 to 3 of 3

VBA - Application.Ontime - When Application Close

  1. #1
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    VBA - Application.Ontime - When Application Close

    Hi,
    I need to run a application every-weekday at 7 AM from 1/11/2019 to 31/12/2019.

    Considering that excel might not be open at those times, is it possible using application.ontime to make this happen (somewhere in the background)

    OR, even open the excel, run the VBA code and then close the excel after the code is carried out ?

    Thanks for your help.

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: VBA - Application.Ontime - When Application Close

    Possibly using windows task scheduler to open the xl file with your code in the workbook_open routine.

  3. #3
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: VBA - Application.Ontime - When Application Close

    THanks

    Wondering if it would be possible to run / control task scheduler from VBA / APIs ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA - Application.Ontime Cancel Fails to Method 'ONTIME' of Object 'Application'
    By LordAzuRa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2016, 03:21 PM
  2. [SOLVED] Help with Application.OnTime (was Application.Wait Now)
    By Walter12 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-29-2012, 01:18 PM
  3. use of Application.ontime
    By katto01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2012, 09:58 PM
  4. Close Workbook with Application.OnTime
    By dylanemcgregor in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-30-2009, 11:52 AM
  5. [SOLVED] execute macro; save it and close using Application.OnTime
    By ina in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2006, 12:25 PM
  6. [SOLVED] difference application.quit & application.close
    By Pierre via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2005, 04:00 PM
  7. Help .. stopping Application.Ontime when you close a workbook
    By L2B in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2005, 06:43 AM

Tags for this Thread

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