There are a lot of questions here to create a macro to save a worksheet as a CSV file. All the answers use the SaveAs, like [this one](https://superuser.com/questions/381861/export-to-csv-from-excel) from SuperUser. They basically say to create a VBA function like this:

```
Sub SaveAsCSV()
    ActiveWorkbook.SaveAs FileFormat:=clCSV, CreateBackup:=False
End Sub

```

This is a great answer, but I want to do an **export instead of Save As**. When the SaveAs is executed it causes me two annoyances:

* My current working file becomes a CSV file. I'd like to continue working in my original .xlsm file, but to export the contents of the current worksheet to a CSV file with the same name.
* A dialog appears asking me confirm that I'd like to rewrite the CSV file.

Is it possible to just export the current worksheet as a file, but to continue working in my original file?