/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 vote187 views1 answer
Vba integer to double
VBA
0 vote152 views1 answer
How to make a if statement with vbs
VBA
0 vote177 views1 answer
Ribbon show/hide
VBA
0 vote162 views1 answer
Vba file size
VBA
0 vote192 views1 answer
Vbscript Trim
VBA
0 vote166 views1 answer
Excel vba show developer tab
VBA
0 vote170 views1 answer
Vbnet check if string is only symbols
VBA
1 vote178 views1 answer
Vbscript convert ascii code to character
VBA
0 vote189 views1 answer
Add text to Shape VBA
VBA
0 vote186 views1 answer
Vba html document reference
VBA