/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 vote241 views2 answers
Excel vba store array and write to sheet
VBA
1 vote207 views1 answer
Perform http request in vb.net
VBA
0 vote194 views1 answer
Vba loop through textboxes
VBA
1 vote194 views1 answer
Excel vba last row of range
VBA
0 vote178 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote249 views1 answer
Excel vba delete columns in range
VBA
0 vote197 views1 answer
Vba extract filename from path
VBA
1 vote187 views1 answer
Random number generator vb.net
VBA
0 vote176 views1 answer
Vba border weight
VBA
0 vote216 views1 answer
Excel vba protect worksheet without password
VBA