vba help - save workbook in csv without changing sheet name - issue

[Mallesh23]

Hi Team,

I am trying to save a workbook in csv format.
Macro saves workbook into csv format but also Changes sheet Name to Recon_.

From Sheet1 to Recon_ . I want name should not get changed.


Below is a code

If Dir(ThisWorkbook.Path & "\output", vbDirectory) = "" Then
        MkDir ThisWorkbook.Path & "\output"
End If
    
    Application.DisplayAlerts = False
    On Error Resume Next
        wbSource.SaveAs ThisWorkbook.Path & "\output\Recon_" & Format(date, "Mmmm_YY") & ".csv", 6
    On Error GoTo 0
    Application.DisplayAlerts = True

Thanks
mg

 

[Yongle]

Yes that is exactly what all test files except one did
As a further test, I renamed one file and Excel simply renames the sheet after opening the file
An exercise in going round in circles