/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 vote211 views2 answers
Excel vba prevent save
VBA
0 vote215 views1 answer
Vba first cell in range
VBA
3 votes219 views1 answer
Excel vba read registry key value
VBA
0 vote250 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote227 views1 answer
Windows Presentation Foundation dark title bar
VBA
1 vote175 views1 answer
Vba Remove Case Sensitivity
VBA
3 votes249 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote239 views1 answer
Label de tableau dans des label.text en VBA
VBA
1 vote175 views1 answer
How to open cmd with vbd
VBA
0 vote215 views1 answer
Type excel.application is not defined vb
VBA