/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 vote232 views1 answer
Vba remove the first character of string
VBA
0 vote205 views1 answer
Excel vba linter
VBA
2 votes223 views2 answers
Excel vba if sunday or staurday
VBA
0 vote195 views1 answer
Vbs exec hidden
VBA
0 vote209 views1 answer
Pivot data source not accepting table named range vba
VBA
1 vote192 views2 answers
Get all column names from excel vba
VBA
0 vote205 views1 answer
Average vba
VBA
1 vote202 views1 answer
How to put a gridpain in a vbox
VBA
0 vote209 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote224 views1 answer
Excel vba DisplayAlerts
VBA