VBA: Specify saved WorkBook name

[Adar123]

Hi all,

I am working with the following syntax to export and save the data in a new file.

ActiveWorkbook.SaveAs FileName:=RatesFilenameMO_CSV, FileFormat:= _
        xlCSV, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
        , CreateBackup:=False, Local:=True

The challenge I face is that this code by default saves data on "Sheet1" inside the new file whereas I also need to rename the "Sheet1" to "Data". I am not familiar with this syntax of saving file, can I specify a sheet name within it?

Thank you.

 

[Coding4Fun]

Have you tried changing the name of the sheet before saving it?

Activeworkbook.Sheets("Sheet1").Name = "Data"

 

[Adar123]

Easier than I thought, thanks!