{"id":11766,"date":"2022-09-20T09:46:21","date_gmt":"2022-09-20T09:46:21","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=11766"},"modified":"2024-03-30T00:19:18","modified_gmt":"2024-03-30T00:19:18","slug":"save-excel-worksheet-as-csv-with-vba","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/vba\/save-excel-worksheet-as-csv-with-vba\/","title":{"rendered":"Save Excel Worksheet as CSV with VBA"},"content":{"rendered":"\n
Visual Basic for Applications (VBA)<\/strong> is a great tool for the automatization of our work. It can also be used to manipulate any Office application (mostly Excel)<\/strong> on any level (sheet, workbook, or application as a whole).<\/p>\n\n\n\n In the example below, we will show how can we manipulate the worksheet from the VBA by saving the worksheet in a specific file type – a CSV file<\/strong>.<\/p>\n\n\n\n For our example, we will use the table with NBA players and their respective teams:<\/p>\n\n\n\nSave Excel Worksheet as CSV with VBA<\/h2>\n\n\n\n