/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 vote118 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote127 views1 answer
How to add line graph vb net
VBA
0 vote129 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote111 views1 answer
Excel vba center userform
VBA
1 vote110 views1 answer
Excel vba hide zero values
VBA
4 votes127 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote69 views1 answer
How to make a if statement with vbs
VBA
0 vote123 views1 answer
Excel delete ever other vba
VBA
0 vote129 views1 answer
Vba round to 2 decimals
VBA
8 votes195 views1 answer
Vba make integer
VBA