Private Sub Application_Startup()....What if it be public

Outlook Discussion in 'Microsoft Office' started by AmjiBhai, Mar 24, 2018.

  1. AmjiBhai

    AmjiBhai

    Joined:
    Feb 21, 2018
    Likes Received:
    42
    Hi friends,

    I have a routine/sub in module 1 that keeps executing every 5 minutes.
    I need that routine to call apart from all good things its currently doing, I want it to call Sub Application_Startup() but that routine is startup routine which only executes each time when Outlook is launched. Can it be called from remaining in module 1 ? do I have to change it from Private Sub Application_Startup() ...to Public Sub Application_Startup()?

    Thanks in advance for your help.
     
    AmjiBhai, Mar 24, 2018
    #1
    1. Advertisements

  2. AmjiBhai

    JohnBgoode

    Joined:
    Jul 7, 2018
    Likes Received:
    1
    You want all your stuff in Application_startup to be used multiple times? Then put it in another sub and call that sub from Startup as well as every 5 minutes form the other sub.
     
    JohnBgoode, Jul 8, 2018
    #2
    AmjiBhai likes this.
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.