rossmiddleto
09-19-2011, 03:47 AM
Hi All,
I am trying to learn how to submit internet forms on web pages and then download the subsequent data to a spreadsheet.
What I want to do is to use the following website: http://sea-distances.com/index.htm (http://sea-distances.com/index.htm) to populate a matrix of country to country shipping distances (using a random/any port in that country) that you can find in a sheet attached to this post.
Would someone please be able to help me, so that I can then go on to tweak/explore your macro and apply it to other types of similar problems?
Any help you can give will be more than appreciated.
Ross
I am trying to learn how to submit internet forms on web pages and then download the subsequent data to a spreadsheet.
What I want to do is to use the following website: http://sea-distances.com/index.htm (http://sea-distances.com/index.htm) to populate a matrix of country to country shipping distances (using a random/any port in that country) that you can find in a sheet attached to this post.
Would someone please be able to help me, so that I can then go on to tweak/explore your macro and apply it to other types of similar problems?
Any help you can give will be more than appreciated.
Ross