XLSX批量转化成CSV

2022-04-16  本文已影响0人  红梅素_2

Sub xls2csv()

    Application.DisplayAlerts = False

    t = ActiveWorkbook.Name

    mypath = ActiveWorkbook.Path & "\"

    myfile = Dir(mypath & "*.xls")

    Do Until Len(myfile) = 0

          If myfile <> t Then

              Workbooks.Open Filename:=mypath & myfile

              ActiveWorkbook.SaveAs Filename:=mypath & Left(myfile, InStr(myfile, ".") -    1) & ".csv", FileFormat:=xlCSV

    End If

    If myfile <> t Then ActiveWorkbook.Close

    myfile = Dir

Loop

Application.DisplayAlerts = True

End Sub

上一篇 下一篇

猜你喜欢

热点阅读