/VBA/Excel vba export sheet as a csv without losing focus of my current workbook

Excel vba export sheet as a csv without losing focus of my current workbook

'VBA function to save current worksheet as a CSV file without losing
'focus. The CSV file is saved in the same directory as the current
'workbook. The Local Separator is utilized:

Sub SaveSheetAsCSV()
  With ActiveSheet
    .Copy
     ActiveWorkbook.SaveAs Left(.Parent.Name, InStrRev(.Parent.Name, ".")) & .Name & ".csv", xlCSV, Local:=True
     ActiveWorkbook.Close False
    .Activate
  End With
End Sub

Source: academy.excelhero.com

Similar codes

0 vote352 views1 answer
Vba round to 2 decimals
VBA
3 votes348 views1 answer
Extract the nth word from a text string
VBA
2 votes337 views1 answer
Vba split string
VBA
2 votes323 views1 answer
Date format for ms chart vb.net
VBA
0 vote331 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote324 views1 answer
Vbnet add new ecel sheet
VBA
0 vote315 views1 answer
Enter into cells data grid view
VBA
0 vote341 views1 answer
Vba copy file
VBA
0 vote354 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote358 views1 answer
Vba add shape oval
VBA