Tag Archives: opentext

The task was to use text files that are created by an external program on a daily basis to create a workbook that contains those files’ data in monthly spreadsheets. The good thing is, the text files were named ‘DATAYYMMDD’, so there is a keyword (“DATA”) and the actual date in year, month and day form.
Continue reading

Posted in Excel, MS Office | Tagged , , , , | Comments Off on Excel/VisualBasic: Turning daily textfiles into monthly spreadsheets