Creating a VBA Script to save in a current month's folder (create folder as needed)

[Bob Phillips]

Dim folder As String

    folder = "B:\NCC\ntsd\cable\" & Format(Date, "mmmm") & "\"
    On Error Resume Next
    MkDir folder
    On Error GoTo 0
    With ActiveWorkbook
    
        .SaveAs Filename:=folder & .Name
    End With