Validating vba statements if false continue

**ranuse** · 11-08-2010, 11:30 AM

Hi,

Is there a way to validate vba statements? For example, I have some code that opens specific workbooks in a directory. Currently, if a workbook with a certain name is not found the macro will stop running and throw an error message. I would like to know if there is code that will check if that statement is false (it can't find the element it's looking for) and just continue to the next line of code instead of throwing an error message.

Thanks.

**shg** · 11-08-2010, 11:59 AM

One way:

    Dim wkb As Workbook
    
    ' ... other code ...
    
    Set wkb = Nothing
    On Error Resume Next
    Set wkb = Workbooks("Bob.xls")
    On Error GoTo 0
    If wkb Is Nothing Then Exit Sub

    ' carry on ...

**ranuse** · 11-08-2010, 12:02 PM

Thanks for the response.

Will this work for any code statement? Or is there a more generic way to check if a statement returns error?

**shg** · 11-09-2010, 11:32 AM

More generically, you can do something like this:

    On Error Resume Next
    Set wkb = Workbooks("Bob.xls")
    If Err.Number Then
        ' there was an error
    End If

Validating vba statements if false continue

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Validating vba statements if false continue

Re: Validating vba statements if false continue

Re: Validating vba statements if false continue

Re: Validating vba statements if false continue

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions