/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

31 votes267 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
1 vote156 views1 answer
Vbscript convert ascii code to character
VBA
1 vote149 views1 answer
Excel vba last column in range
VBA
1 vote163 views1 answer
Excel vba last row of range
VBA
0 vote147 views1 answer
Vba get text file content
VBA
0 vote157 views1 answer
Excel vba protect worksheet without password
VBA
0 vote158 views1 answer
Vbnet round to nearnest thousand
VBA
1 vote142 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote151 views1 answer
Excel vba remove formatting from cell
VBA
3 votes151 views1 answer
Excel vba last row in range
VBA