/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

-1 vote312 views1 answer
How save excel through visual basic
VBA
0 vote304 views1 answer
Vba excel parser xml
VBA
1 vote297 views1 answer
Vbs run
VBA
0 vote286 views1 answer
Vbscript check if string contains
VBA
0 vote284 views1 answer
Label de tableau dans des label.text en VBA
VBA
1 vote322 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote300 views1 answer
Average vba
VBA
0 vote288 views1 answer
Vbscript Trim
VBA
4 votes293 views2 answers
Vba create folder if not exist
VBA
0 vote296 views1 answer
How to add line graph vb net
VBA