A A augustus NARAYANK991 augustus wrote on NARAYANK991's profile. Jun 10, 2022 need help in exporting excel to csv, we need " in each field when exported to CSV
Dim fn As String
fn = "_" & Format(Now, "yyyymmddhhmmss")
ThisWorkbook.Worksheets("Data").Copy
With ActiveWorkbook
Application.DisplayAlerts = False
.SaveAs Filename:="C:\TMU-Export\TMU_Sales" & fn, FileFormat:=xlCSVUTF8
Application.DisplayAlerts = True
.Close savechanges:=False
End With
End Sub