/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 vote183 views1 answer
Excel vba disable alerts
VBA
5 votes177 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote187 views1 answer
Excel vba cell on change
VBA
0 vote193 views1 answer
Excel vba protect scenarios
VBA
0 vote189 views1 answer
Refer to resource using string variable vb.net
VBA
1 vote194 views1 answer
Change the first item in a queue vb.net
VBA
22 votes242 views1 answer
Excel vba check if directory exists
VBA
0 vote226 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
1 vote194 views2 answers
Vba string length
VBA
0 vote189 views1 answer
How to make a a msgbpx in vbs
VBA