Results 1 to 2 of 2

Macro Stops Running

Threaded View

  1. #1
    Registered User
    Join Date
    10-25-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Macro Stops Running

    I have this code that runs the through the first 4 lines. It then stops as I describe below.

    For Privacy concerns I am using generic names for workbooks

    Sub EVERYWEEKLY()
    '
    ' EVERYWEEKLY Macro
    '
    
    '
        Application.Run "'Active Workbook.xls'!SEAFOOD"
        ChDir "W:\Master Books\Unknown"
        Workbooks.Open Filename:="W:\Master Books\Unknown\Unknown Workbook.xls"
        Application.Run "'Macro1.xls'!UPDATE"
    At this point, Unknown Workbook.xls closes but the original workbook is still open and the following Macro need to run. But the whole Macro stops at this point.

        Application.Run "'Active Workbook.xls'!Macro 2"
        Application.Run "'Active Workbook.xls'!Macro 3"
    How do I make the original macro continue after the Unknown Workbook.xls closes and I have my original workbook still open?
    Last edited by 6StringJazzer; 02-02-2015 at 05:54 PM. Reason: Corrected code tags so that closing tag is [/CODE]

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 'True' message box and macro stops running
    By Aaron092 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-11-2014, 09:43 AM
  2. [SOLVED] Macro Stops running after paste values
    By mhawkins91 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-12-2014, 05:23 PM
  3. Macro leaves page where it stops running
    By Steve6386 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-14-2008, 02:38 PM
  4. Protection Stops Macro From Running
    By Keith Burgess in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-11-2008, 07:15 AM
  5. [SOLVED] Macro stops running after file has moved
    By LWhite in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2005, 04:06 PM

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