As the subject states I am trying to use VBA to save several sheets as separate csv files though when I do output files contain quotes around the strings
VBA -
Sub SaveSheetAsCSV()
Dim ws As Worksheet
Dim csvFile As String
For Each ws In Worksheets
ws.Copy
csvFile = "C:\Users\Richa\Desktop\New folder (2)\" & ws.Name & ".csv"
Application.ActiveWorkbook.SaveAs Filename:=csvFile, _
FileFormat:=xlCSV, CreateBackup:=False
Application.ActiveWorkbook.Saved = True
Next
End Sub
Input example :
Output example :
VBA -
Sub SaveSheetAsCSV()
Dim ws As Worksheet
Dim csvFile As String
For Each ws In Worksheets
ws.Copy
csvFile = "C:\Users\Richa\Desktop\New folder (2)\" & ws.Name & ".csv"
Application.ActiveWorkbook.SaveAs Filename:=csvFile, _
FileFormat:=xlCSV, CreateBackup:=False
Application.ActiveWorkbook.Saved = True
Next
End Sub
Input example :
Output example :