/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 vote138 views1 answer
Freeze panes vba
VBA
0 vote134 views1 answer
Vba DisplayGridlines
VBA
0 vote151 views1 answer
Regex numeric digits
VBA
2 votes135 views1 answer
Date format for ms chart vb.net
VBA
3 votes139 views1 answer
Vba request json
VBA
1 vote138 views1 answer
Excel vba close form escape key
VBA
0 vote150 views1 answer
Vba clear collection
VBA
0 vote150 views1 answer
Vbnet click on dgv cells
VBA
0 vote150 views1 answer
Excel filter by date not working vba
VBA
2 votes146 views2 answers
Vba code to remove duplicates from a column
VBA