/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 vote170 views1 answer
Excel vba linter
VBA
0 vote174 views1 answer
Vba change active sheet
VBA
1 vote173 views1 answer
Set font for ms chart vb.net
VBA
0 vote150 views1 answer
Remove frist letter from string vbnet
VBA
2 votes113 views1 answer
Excel vba pause
VBA
0 vote212 views1 answer
Excel vba protect content
VBA
0 vote166 views1 answer
Menus act like radio buttons vb.net
VBA
1 vote176 views1 answer
Excel date to unix timestamp
VBA
-1 vote166 views1 answer
Vba code to add new column in table
VBA
0 vote158 views1 answer
Vba like with wildcard
VBA