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
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
Other Videos By codecaine
Tags:
VBA
Exel
lines
line
count
function
subroutines
filesystemobject
regular
expressions
coding
tutorial