/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

5 votes131 views1 answer
Xl vba double quotes in string literal
VBA
0 vote125 views1 answer
Send text to clipboard vb.net
VBA
1 vote135 views1 answer
Excel date to unix timestamp
VBA
0 vote128 views1 answer
Excel vba urlmon
VBA
0 vote140 views1 answer
Thread sleep vb
VBA
0 vote142 views1 answer
Excel vba set cell value to empty
VBA
0 vote117 views1 answer
How to format a textbox as date vb net
VBA
0 vote129 views1 answer
Menus act like radio buttons vb.net
VBA
1 vote120 views1 answer
Vba declare api 64 bit 32 bit
VBA
3 votes155 views2 answers
Vba date to string
VBA