/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 vote213 views1 answer
Vba remove numbers from string
VBA
0 vote268 views1 answer
Excel vba protect sheet
VBA
1 vote231 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote228 views1 answer
Not allow form to be resized
VBA
0 vote226 views1 answer
Visual basic msdos
VBA
0 vote228 views1 answer
Loop through lines in text file vb net
VBA
0 vote208 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote215 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote220 views1 answer
Refer to resource using string variable vb.net
VBA
1 vote228 views1 answer
Vbscript convert ascii code to character
VBA