File Path VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. File Path
  4. Saves the active worksheet in the workbook named MyWorkbook xls as a comma-delimited text file named test csv
Sub csvSave()
    Workbooks("MyWorkbook.xls").SaveAs Filename:=ActiveWorkbook.Path & _
              "\test.csv", FileFormat:=xlCSV
End Sub