VBA save worksheet code example

Example 1: vba saveas xlsb

ThisWorkBook.SaveAs pFilePath, xlExcel12		' xlExcel12 is xlsb (binary)

Example 2: excel vba save workbook

ThisWorkbook.Save