PaperWolf: Training
Flu!! 2
QuadroPop60
Categories
- blog (13)
- game development (42)
- grids (9)
- mochiads (30)
- monetization (18)
- xperiment (8)
- Games (6)
- games related (8)
- Cheat (2)
- Walkthrough (5)
- MS Office 2003 (5)
- PHP (3)
Category Archives: MS Office 2003
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’, … Continue reading
Posted in Excel, MS Office 2003
Tagged Excel, import text file, macro, opentext, visual basic
Leave a comment
Let’s assume, you got 12 worksheets named with year and month. Each sheet contains several values for every day. To put them all together I recommend a combination of the Excel functions CONCATENATE and INDIRECT (the real dynamic duo if … Continue reading
Getting rid of old calendar items that waste storage capacity is easy.
Setting up a workbook Open Excel and create a blank workbook. The default settings will create three Worksheets, that’s enough. My personal settings only create one sheet, the others are inserted by ‘Insert->Worksheet’. For the beginning we need two sheets. … Continue reading
Within MS Excel one can adjust the height of a row by dragging the boundary below the row heading until the row is the wanted height or double-click the boundary to get an automatically adjusted height that fits the content. … Continue reading