How to convert multiple .XLSL sheets to .CSV from a book and export it individually to the desktop?

Question

How to convert multiple .XLSL sheets to .CSV from a book and export it individually to the desktop?

Navigation

#1 by (0 votes)

0

I want to save multiple sheets by the name itself. And that are converted from .xlsx to .csv (separated by commas).

vba excel-vba

asked by anonymous 31.05.2017 / 21:59

1 answer

Personalized WebApi Response Error installing programs in windows 10

score 0 · Accepted Answer

RESOLVED:

Sub guardar()
Dim folha As Worksheet

For Each folha In ActiveWorkbook.Worksheets
folha.SaveAs "C:\Users\" & Environ("Username") & "\Desktop\CSV\" & folha.Name & ".csv", xlCSV

Next
End Sub