Excel VBA How get line counts in a single file or multiple files tutorial

Channel:
Subscribers:
4,090
Published on ● Video Link: https://www.youtube.com/watch?v=Vmmxmz8B3MI



Category:
Tutorial
Duration: 9:24
438 views
3


This is a tutorial on how to get line counts in plain text files. You can get lines counts in either unix on windows based text files. Since I use regular expression to achieve this if there is some other termination character that can be used also. I have updated the code after this video was made to read large file size quickly. The other method took a while to read large file sizes.

Excel File code example can be downloaded here https://drive.google.com/open?id=11ISpW8zayTqo1ucw6kcPbiwTv-MdkDFu

PasteBin text version of code can be copied here https://pastebin.com/BSqNtVBR







Tags:
VBA
Exel
lines
line
count
function
subroutines
filesystemobject
regular
expressions
coding
tutorial