VBA reads a large text file line by line in reverse

VBA Question

There is a large log file (about 500,000 lines), I need to read it line by line in reverse order, i.e. from the last line to the first line. I know that I can use FileSystemObject in a Microsoft Scripting Runtime Runtime link, but there is no such option as reverse for the ReadLine method in TextStream

Now, the only way I can think of it is to have a counter and skip the previous lines for every line I read, but definitely not enough. Any suggestion code / algo would be much appreciated.