Results 1 to 5 of 5

Application Run not working

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-23-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 365
    Posts
    166

    Application Run not working

    I am using the below code to copy & paste and export to PDF, but I keeping breaking on Application Run at the bottom. Any help?
    Thanks.
    Sub Update()
    
    ' Update Macro
    
    Application.CutCopyMode = False
        Workbooks.Open Filename:= _
             "k:\path\paths\Final\MSP_M.xlsm"
    
        Cells.Select
        Selection.Copy
        Windows("City of Calgary.xlsm").Activate
        ActiveWorkbook.Worksheets("Raw").Activate
        Range("A1").Select
        ActiveSheet.Paste
        Application.CutCopyMode = False
            Windows("MSP_M.xlsm").Activate
                ActiveWindow.Close
                
         Windows("Cit.xlsm").Activate
         ActiveWorkbook.Save
         
             ThisWorkbook.Sheets(Array("a", "b", "c")).Select
    
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "s:\Stats\Test Title Page Merge vba\Cit.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, _
         IgnorePrintAreas:=False, OpenAfterPublish:=False
    
    Application.Run "Merge"
    
    End Sub
    Last edited by Leith Ross; 03-28-2016 at 06:58 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Application.Match not working.
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-08-2015, 08:16 PM
  2. Application.COnvertformula Not Working
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2015, 10:49 AM
  3. Application.ScreenUpdating not working with Application.Run
    By WaqasTariq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2012, 02:24 PM
  4. [SOLVED] Application.ScreenUpdating not working
    By UsmanBPD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2012, 05:19 AM
  5. Application.DisplayAlerts not working
    By yogesh thakker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2010, 05:07 AM
  6. Application.Run not working
    By Lokutus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2006, 04:25 PM
  7. Application.FileSearch is not working??
    By alondon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-18-2005, 12:06 AM

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