ExcelVBA file splitter idea
There are a bunch of fixed length files and length field definitions that we need to break down by length using Excel. How to store length field definitions and splits? 1.Save the copied column definitions into a table, preceded by a column filename.
How does this look like a list of documents? VBA programs can scan but provide dynamically triggered updates, or pivot plus VBA refresh. 2.File name information saved to another table? There are more manual steps.
It occurred to me this morning that I could start by converting in a table: stitching the length type definitions separately into a specific form to store in the columns of the filename list. Unfinished business.