Wednesday, December 31, 2025

Excel VBA code to create XLSX file from a CSV file

VBA code to create a XLSX file from a CSV file. It also shows how to auto fit all columns, apply an auto filter to all columns and freeze the first row.

GitHub code: https://github.com/64board/ExcelVBA/blob/master/CreateXLSX.bas

Another interesting idea is to control running code when the workbook is opened using a flag file.

GitHub code: https://github.com/64board/ExcelVBA/blob/master/ThisWorkbook.cls 

No comments: