Post reply

VBA Error Handling When Opening Another Macro

  • August 8, 2019 at 7:21 pm

    #3670029

    I have a process in which a macro loops through a list of other macros to run. I'm trying to add error handling in the parent macro so that if one of the other macros being called errors then it won't pop up with an alert and it will also close out and move on to the next macro in the list. Here is what I'm experimenting with but I'm finding it does not control the list of macros being opened.

    Sub Test()
    Application.DisplayAlerts = False

    On Error GoTo ErrorHandling
        
    Workbooks.Open Filename:= "C:\temp\SubMacro.xlsm"
        
    Done:
        Exit Sub
    ErrorHandling:
        MsgBox "The following error occurred: " & Err.Description
    End Sub

    Does anyone know if what I'm trying to achieve is possible?

  • August 8, 2019 at 7:24 pm

    #3670030

    Looks like you are in the entirely wrong forum. This is a forum for SQL Server questions. You need to find a place where they discuss Excel.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • August 8, 2019 at 7:28 pm

    #3670031

    That's why I posted it under the Programming --> General category. The Programming category has subcategories such as PowerShell and testing methodologies so I did't think it was too far fetched and figured I would give it a shot.

  • August 8, 2019 at 7:50 pm

    #3670033

    Try utteraccess.com

    In spite of the name, they discuss all MS Office stuff there.

  • August 9, 2019 at 12:03 pm

    #3670204

    Thanks pietlinden!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply