I uploaded some Java code that I wrote earlier this year that creates a .XLSX Excel file from PDF file.
GitHub code: https://github.com/64board/account_summary_u
My digital hodgepodge
I uploaded some Java code that I wrote earlier this year that creates a .XLSX Excel file from PDF file.
GitHub code: https://github.com/64board/account_summary_u
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