>>360 ぐぐるんじゃなく自分で作れるようになると楽だよ Sub foo() Application.DisplayAlerts = False For Each シート In ThisWorkbook.Worksheets シート.Activate ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\" & シート.Name & ".csv", _ FileFormat:=xlCSV, CreateBackup:=False Next Application.DisplayAlerts = True End Sub