Web Query using VBA

[ianclegg]

Hoping that someone can help

I am trying to update a table in an access database storing war grave locations from memorial data.

I want to query the cwgc.org website automatically using vba to retrieve the location of the cemetery or memorial that the person is located in or on, I know the Surname, First name, Initial and the service number of the soldiers and was hoping to use that data as the key for the search.

I cannot understand how to write the code.

Thanks in anticipation

Ian Clegg

 

[plog]

I don't think you can do this programatically, you will probably have to do it socially. It seems that site is either a governmental or non-profit, I would contact them to see if they would allow you access to their database or provide you some sort of api so that you can query it.

From a technical standpoint, that site doesn't lend itself to scraping. It doesn't pass search parameters in the query string, so you can't build one using the data you have; the source doesn't say what url it is posting data to so you can't spoof that.

Your best bet is to contact them.

 

[ianclegg]

Thanks for the helpful reply, I will contact them

Ian Clegg