vba to close workbook

[CRAIG20]

Hi.

I would like a macro that closes another spreadsheet at the end of a macro. The sheet always starts with the name 'formdata' but may have different number&letter sequence after the name. So to catch all I want the vba to close the file beginning with 'formdata'


Something like:
Workbooks("formdata.csv").Close SaveChanges:=False

Thanks in advance

 

[Norie]

Is there only one file with a name starting with 'formdata...' open?

If there is try this.

Dim wbForm As Workbook

    For Each wbForm In Application.Workbooks
        If wbForm.Name Like "formdata*" Then
            Exit For
        End If
    Next wbForm

    If Not wbForm Is Nothing Then
        wbForm.Close SaveChanges:=False
    Else
        MsgBox "formdata workbook not found!"
    End If

 

[CRAIG20]

Thank you