Web query

  • Thread starter Non-profit organization - please help
  • Start date
N

Non-profit organization - please help

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple field values in a single query/report 2
Table Setup and Reports Suggestions 1
Hyperlink imported data into worksheet with dated formate 0
Senior Citizen needs help with complex formula 4
report using a subreport based on a crosstab query 5
query problem? 1
How do I create a table on a new worksheet from other worksheet da 2
Tricky Accounting query - and not sure how to build it 2

Top