/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 vote280 views2 answers
Excel vba store array and write to sheet
VBA
0 vote221 views1 answer
Vba sort multiple columns
VBA
0 vote233 views1 answer
Ribbon show/hide
VBA
5 votes249 views1 answer
Excel vba low word from Long Integer
VBA
0 vote221 views1 answer
Excel vba scroll to cell
VBA
1 vote213 views1 answer
Excel vba first and last row and column in range
VBA
0 vote242 views2 answers
Vb.net include quotes in string
VBA
0 vote228 views1 answer
Type excel.application is not defined vb
VBA
0 vote240 views1 answer
Vba cell all borders
VBA
0 vote158 views10 answers
Vba excel create event log
VBA