Senin, 30 Juli 2012

Re: [ExcelVBA] Access the WEB from EXCEL

 


Hi,

Have you tried googling for this. A quick search with "Excel data from web" gave me 467 million hits!!

Lisa

Sent: Fri, Jul 27, 2012 6:35 pm
Subject: [ExcelVBA] Access the WEB from EXCEL

I have a spreadsheet that needs data from the WEB.

I have the URL, the navigation within the website, and the prompts I need to
fill in once I am there.

So, I do I program that into a macro and then extract the information from the
website once the data is returned?

Here is the data from the spreadsheet:

Country City Postal Code
Row:
USA Solon 52338
USA SUNNYVALE 65111

Here is the website:

http://www.freemaptools.com/find-uk-postcodes-inside-radius.htm

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___

Tidak ada komentar:

Posting Komentar