/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 vote182 views1 answer
VBA Sleep Snippet
VBA
4 votes126 views2 answers
Vba last row
VBA
1 vote1.2K views1 answer
Vba Remove Case Sensitivity
VBA
1 vote219 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote166 views1 answer
Excel vba center userform
VBA
1 vote173 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote171 views1 answer
Vba like with wildcard
VBA
0 vote198 views1 answer
Excel vba first column in range
VBA
5 votes209 views1 answer
Vba low word from Long Integer
VBA
3 votes179 views1 answer
Vba make long from two shorts
VBA