Categories
- blog (13)
- game development (61)
- Games (9)
- games related (9)
- Cheat (2)
- Komplettlösung (d) (3)
- Walkthrough (3)
- MS Office (7)
- PHP (3)
- Tutorial (8)
- Intermediate (1)
- Tutorial Series (15)
- Grid Based Games (8)
- Terrain Modification (7)
- Uncategorized (1)
Tag Archives: macro
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 Excel, import text file, macro, opentext, visual basic
Comments Off on Excel/VisualBasic: Turning daily textfiles into monthly spreadsheets