/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 vote156 views1 answer
Get current url vb.net
VBA
1 vote150 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote164 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote158 views1 answer
Vba collection contains
VBA
3 votes165 views1 answer
Vba continue for each loop
VBA
0 vote153 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote155 views1 answer
Vba shape transparent
VBA
0 vote164 views1 answer
Vba remove last vbcrlf
VBA
0 vote153 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote203 views1 answer
Vba excel do not recalculate before save
VBA