I am looking for a script that helps me consolidate the status of three programs being carried out for various cities.
Currently how the things are:
There are three programs, say for example
the above programs are carried out and tracked for various cities and the status can be seen through a link (I guess HTML page)
the URL that are formed has common prefix with city as parameter at the end
1. for Audit the URL would form something like below
2. for Survey the URL would form something like below
3. for Competency the url would form something like below
Now, the page that loads on all the above urls would have some description about the program at the begning followed by the data in a fixed tabular format with two columns (1st column shows heading and 2nd column shows the value) that is same for every program.
in the table, the 5th Row shows the "Status" and its value.
What I am looking for:
Now, I am looking for a vb script that will pull the name of the cities from a text file, generate the urls in background and pull out the status value from each url and display the same in below format in html file or excel file
City | Audit | Survey| Competency
Pune | Completed| In Progress | Initiated
Mumbai | Completed | Completed | Completed
Delhi | In Progress | Completed | Completed
Thanks in advance