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:
Post a Comment