Auto save CSV problem

[Cameraman84]

Hello

I have a small problem...I try to auto save with VBA my sheet with name PAGE CSV but when I open the new file, the vba save the active Sheet and not the sheet with the name PAGE CSV...What I must change to my code plese?


Application.DisplayAlerts = False
Sheets("PAGE CSV").SaveAs Filename:=ThisWorkbook.Path & "\PAGE CSV.csv", FileFormat:=xlCSVUTF8, CreateBackup:=False

Thanks
John K.

 

[Joe4]

I am confused. CSV files, by definition, only can have one sheet (it is a flat file).
So, how you can open a CSV file and have multiple pages?

I think some more detail is needed here.
Are you trying to copy something from another file to the CSV file?
If so, how many sheets does the other file have, and what are you trying to copy and to where?