/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 vote255 views1 answer
Add text to Shape VBA
VBA
1 vote264 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote248 views1 answer
Vbscript for loop
VBA
0 vote242 views1 answer
Excel vba chrw max value
VBA
0 vote237 views1 answer
Excel vba range contains
VBA
0 vote226 views1 answer
Vba argument is set
VBA
0 vote230 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote244 views1 answer
Excel vba hide gridlines
VBA
0 vote248 views1 answer
Vba table header name
VBA
0 vote227 views1 answer
Docker vboxmanage not found
VBA