Change VBA to export data as CSV

[PaulaGon]

Hello,


I have a table that I need to export and save as a CVS file.
Initially I had a code to export and save the table as a new excel file, with an specific name, but now I need to save data to csv format.
I already tried but I was not able to change the vba code…

Sub NewFILE()
Application.EnableEvents = False
    Folha1.Range("B15:D" & Folha1.UsedRange.Columns(1).Find("*", , xlValues, , , xlPrevious).Row).Copy
    Workbooks.Add
    ActiveSheet.Name = Folha1.[C4].Text
    [A1].PasteSpecial xlPasteValues
    [A1].PasteSpecial xlPasteFormats
    [A1].PasteSpecial xlPasteColumnWidths
    [A1].Select
    Application.CutCopyMode = False
    Application.Dialogs(xlDialogSaveAs).Show Folha1.Range("C4")
    Application.EnableEvents = True
End Sub

Any suggestions would be greatly appreciated!


Thank you in advanced.

 

[welshgasman]

Just go through the steps with Record macro switched on ?

Or look at this link and set the format option on the save ?

https://stackoverflow.com/questions...sv-files-with-filenameworksheet-name-using-vb

HTH

 

[PaulaGon]

Hello welshgasman,


Thank you for your quick reply...


I tryed to change the code looking to the examples of the link you sent me but i was not able correct the vba code..


PG

 

[welshgasman]

I would just switch on the macro recorder, then go through the steps required, if I did not have anything to hand.

FWIW in one of my workbooks I have

' Save the CSV version
ActiveWorkbook.SaveAs Filename:=strOutFile, FileFormat:=xlCSV, _
    CreateBackup:=False

HTH

 

[PaulaGon]

Hello welshgasman,

I already had tried to switch on the macro recorder and change the steps in the original code.... but I was not able to change the vba code…

Thank you for the help.

I inform I am doing cross-post:https: //www.excelforum.com/excel-programming-vba-macros/1254321-change-vba-to-export-data-as-csv.html

 

[PaulaGon]

Hello,


I want to inform that I will be no longer monitoring this thread
But I want to thank you for all the help related to this topic!!!


Best regards,