VBA Script to open webpages and extract information

**mss90** · 05-09-2016, 03:01 AM

Hi guys

I got a model in ArcGIS thats pumping out 17 excel spreadsheets that I merge using excel VBA script into 1 spreadsheet (Sheet1). Not all of these tables contain the same type of information so column D from one spreadsheet might contain a different type of information than what it does in another.

Anywho, a lot of these tables contain a column containing a web link to a page with a coupple of paragraphs with some text. Would it be possible to write a script using web scraping for example so that it;
1. Locates which column that contain the links (as previously stated, the link might be in column D in on table but column C in another for example).
2. Open the HTML link and search through the body of text on the web page for a bunch of species that I have in a long list in another excel spreadsheet (Sheet2) (all in column A)
3. If it finds species "x" to copy paste species "x" into the merged spreadsheet (Sheet1)

Thanks in advance

**kalbasiatka** · 05-09-2016, 03:21 AM

Hi. Food for thought

**mss90** · 05-09-2016, 03:24 AM

Thanks for fast reply, although when I try your link Im getting; "Sorry - no matches. Please try some different terms."

**kalbasiatka** · 05-09-2016, 03:38 AM

type in forum search "xmlhttp"

**mss90** · 05-09-2016, 06:36 AM

Okay so I got the folling script;

Please Login or Register  to view this content.

I found that "Dim myValue As String: myValue = "[@id="faktaark"]/dl[2]/dd[23]"" does not work, I attempted to use both the "selector" and "xpath" of the paragraph of relevant text from the HTML web page but it does not seem to work. What em I doing wrong?

**kalbasiatka** · 05-09-2016, 06:43 AM

What exactly need to with this page? Show the screenshot of the page itself.

**mss90** · 05-09-2016, 07:04 AM

faktaark.JPG

So thats a picture of most of the page. Idealy I would like the script to search the "Naturtype" paragraph for a lot of species to see of they are in that text. However as its a little complex for a novice for me I am now just trying to copy the entire paragraph into A1

**kalbasiatka** · 05-09-2016, 08:45 AM

Please Login or Register  to view this content.

**mss90** · 05-10-2016, 02:38 AM

How can I only select the "naturtyper" paragraph? naturtyper.JPG

**mss90** · 05-10-2016, 03:02 AM

Originally Posted by mss90

How can I only select the "naturtyper" paragraph? Attachment 459898

I managed using this method;

Please Login or Register  to view this content.

VBA Script to open webpages and extract information

LinkBack

Thread Tools

Rate This Thread

Display

VBA Script to open webpages and extract information

Re: VBA Script to open webpages and extract information

Re: VBA Script to open webpages and extract information

Re: VBA Script to open webpages and extract information

Re: VBA Script to open webpages and extract information

Re: VBA Script to open webpages and extract information

Re: VBA Script to open webpages and extract information

Re: VBA Script to open webpages and extract information

Re: VBA Script to open webpages and extract information

Re: VBA Script to open webpages and extract information

Thread Information

Users Browsing this Thread

Similar Threads

VBA - Second Script to Monitor Timed-out Webpages

VBA code to extract data from multiple webpages to excel

[SOLVED] VBA SCRIPT to copy information to different worksheets based on a criteria

Extract a Specific data from multiple webpages to excel

Macro to Open webpages in new instance of Chrome, close after X time.

VBA script to extract data from server

VBA script for extract, merge and deleting rows

[SOLVED] VB script and disappearing information

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions