Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web query
I am trying to pull certain data from webpages in separate columns using
existing hyperlinks within Excel. For example, for the following hyperlink "http://scoweb.sco.ca.gov/UCP/PropertyDetails.aspx?propertyRecID=5145088" I am trying to create a formula or macro / VBA to capture the following contents for the following fields: Owner's Name: AMERICAN CANCER SOCIETY Amount: $70.00 Type of Property: Vendor payments Reported By: CITIZENS BUSINESS BANK Reported Address: UNKNOWN , UNKNOWN |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Problem with .Background Query option of ODBC Query | Excel Programming |