+ Reply to Thread
Results 1 to 2 of 2

VBA in task scheduler closes other opened excel tabs after the execution

  1. #1
    Registered User
    Join Date
    04-20-2021
    Location
    Hyderabad, India
    MS-Off Ver
    Office 365
    Posts
    1

    VBA in task scheduler closes other opened excel tabs after the execution

    Hello,

    I have implemented a macro in vba that refreshes the data from a database and scheduled it using the windows task scheduler. I have attached the vbs code for reference:

    Please Login or Register  to view this content.
    Windows task scheduler closes other opened excel tabs after the macro execution. I tried executing on other systems also. Sometimes it's working (doesn't close all excels) sometimes it doesn't.

    Please help me resolve this issue.
    Last edited by Manikanta9333; 04-20-2021 at 10:05 PM. Reason: To add code brackets

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,744

    Re: VBA in task scheduler closes other opened excel tabs after the execution

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

+ 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. Replies: 4
    Last Post: 01-06-2020, 11:38 AM
  2. Replies: 3
    Last Post: 12-31-2019, 01:46 PM
  3. Code Execution Hangs When Run by the Task Scheduler
    By dflak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-27-2019, 10:21 AM
  4. Task Scheduler Stopped Working - Excel
    By profector in forum Microsoft Windows Help
    Replies: 2
    Last Post: 01-28-2014, 11:11 AM
  5. Running Excel from task scheduler. Scheduler doesn't end
    By tony h in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2013, 09:49 PM
  6. Run Excel and macro using Windows Task Scheduler
    By MilroyD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2013, 11:24 PM
  7. [SOLVED] Use Task Scheduler to automatically run Excel workbook
    By John Hazel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2006, 09:10 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