LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default HELP: Macro to conduct web query and return results

Hey Guys,

I am only knowledgable on the basics of macros so I have no clue on how to
interact with the web.

Basically what I require is thus:

I have a file of postcodes in Australia which i obtained through:

http://www1.auspost.com.au/postcodes/index.asp?sub=2

i downloaded the second option, the postcode booklet database

now i need a macro to go through this file and find every different
city/suburb/town mentioned then for each one mentioned, send it and the
corresponding state/territory (so as to cater for same place names in
different states) to the following website:

http://www.ga.gov.au/map/names/

obviously the name will go into the "place name" the place type will always
be "towns and localities" and the state will correspond with the state in
the spreadsheet, although the state part on query is not important.. only on
the results found.

after the data is put into the page, the site will return results

I would like the macro to find the matches and copy them into an excel
sheet.. all official results under the "status" field, that is.

Why I need this is so I can create a complete list of all latitude and
longitude coordinates for every location in Australia so then I can
calculate distances between places.

Is anybody able to help inform me as to how best go about this, or is there
a macro out there that i can slightly modify or tell what I want it to do
and will do it?

If anybody can help, it would very very much appreciated.

Thank you in advance.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to check data from excel list against access query and return value back to excel dreamkeeper Excel Worksheet Functions 0 October 31st 07 07:26 PM
How do I conduct linear regression in Excel with more than 16 x's Ken Excel Worksheet Functions 5 September 22nd 05 01:02 PM
Solver GUI works fine, but the VBA macro won't return any results Ben Anderson Excel Programming 3 June 24th 05 02:48 PM
Macro to write to webpage & query results Ross[_8_] Excel Programming 0 July 8th 04 02:34 AM
How can I list the results of my macro without overwritng previous results? mattip Excel Programming 3 November 28th 03 03:45 AM


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"