Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting data from web app
I was wondering if there was a way to get to data through excel VBA that is:
1) the data is in a "http://www..... .aspx" URL when I go the URL above (and I didn't type the entire URL) I get a list of names like this Brian Ackerley, QKA Vanguard Phoenixville PA Michelle R. Ackerman, QKA First Merit Bank Akron OH Thomas R. Ackmann Baden Retirement Plan Services Fort Wayne IN Lucian B. Acuff Acuff & Associates, Inc. Brentwood TN Beau C. Adams, QPA, QKA The Benefit Consultants Group Delran NJ The name is a hyperlink to another HTML page that pops up...but I don't see an URL address. is there anyway to write VBA to automate this process somehow? Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting data from web app
People say if i can't get the data off the internet, nobody can. Here is a simple example. Just perform a googled search for "Joel IE explorer vba". I numer of the hnits are people I help either at microsoft or codecage help sites. Sub GetZipCodes() ZIPCODE = InputBox("Enter 5 digit zipcode : ") Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True URL = "http://zip4.usps.com/zip4/citytown_zip.jsp" 'get web page IE.Navigate2 URL Do While IE.readyState < 4 Or _ IE.busy = True DoEvents Loop Set Form = IE.document.getElementsByTagname("Form") Set zip5 = IE.document.getElementById("zip5") zip5.Value = ZIPCODE Set ZipCodebutton = Form(0).onsubmit Form(0).submit Do While IE.busy = True DoEvents Loop Set Table = IE.document.getElementsByTagname("Table") Location = Table(0).Rows(2).innertext IE.Quit MsgBox ("Zip code = " & ZIPCODE & " City/State = " & Location) End Sub -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=151075 Microsoft Office Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry | Excel Programming | |||
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry | Excel Programming | |||
Reliable Data Conversion,Data Formats and Data Entry Services by DataEntry India | Excel Programming | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data | Excel Programming |