Macro Scope –
We need to basically create a loop through each text file in a folder and extract the data records from the text files that read:
We just want to scrape these categories:
These sections get ignored:
Justices of the Peace-New
Commissioners of Deeds-New
But then the data will need to be exacted from the text files and put into excel using the example as ‘finished example’ as a guide.