In a previous video Micro Tutorial here at Experts Exchange, I presented my CapsLockOSD program, which is a utility that constantly shows the state of the CapsLock key (ON or OFF) in the system tray. This video Micro Tutorial presents a modified version of CapsLockOSD with two enhancements: (1) the ability to create a stand-alone executable (an EXE file) that can run on a system without AutoHotkey installed and (2) an option to run automatically whenever Windows starts. If you do not require either of these new features, you may stick with the previous version of the program.
Note: The video does not demonstrate how to compile the AHK source code into an EXE file, so I've included Steps 5 and 6 below to explain that.
Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways.
For this article, I'm going to demonstrate an effective way to find the last line content of a large text file using VBA codes.