Hello,
Hard work already done, I can send you a proof of concept if you want. I can access directly through code to the results page. I assume you only need to filter based on the parameters specified inside the PDF, right? I mean filing date range and Status OPEN...
If this is the case, I can do the job within 1 day.
I've created a macro inside an XLS. This macro creates a browser object, and this browser object gets the contents of the page you referred. Then, fills "date from" and "to" fields and sets "estate status" automatically based on your selections on cells A1, A2 and A3 of sheet1. Next, it presses automatically the "Search" button, and gets the listing. All this is already done.
Job to be done is:
.- Go through all page results grabbing "Estate number" Link
.- Go through all "Estate number" links to parse contact information
You can rename it to XLT and save each periode in one XLS. So that's all.
Please, accept my proposal and help me to get reputation, you will be satisfied. We can talk about price also, I desperately need to start working!
Thanks!