excel vba export sheet as a csv without losing focus of my current workbook

The solution for “excel vba export sheet as a csv without losing focus of my current workbook” can be found here. The following code will assist you in solving the problem.

Get the Code! 
‘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

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts

System.Data.OleDb.OleDbException: ‘No value given for one or more required parameters.’

Bym0nxt3r

The solution for “System.Data.OleDb.OleDbException: ‘No value given for one or more required parameters.’” can be found here. The following code will assist you in solving the problem.Thank you for using DeclareCode; We hope you were able to resolve the issue. More questions on [categories-list]