+ Reply to Thread
Results 1 to 3 of 3

How to search through specific webpages automatically using excel VBA

  1. #1
    Forum Contributor
    Join Date
    04-28-2016
    Location
    Stavanger, Norway
    MS-Off Ver
    365
    Posts
    142

    How to search through specific webpages automatically using excel VBA

    So I made a simple script;

    Please Login or Register  to view this content.
    Im basically wanting to search for different species on this webpage, I was thinking I could do it manually using hotkeys rather than advanced scripts.
    The fist problem is near the top where I em trying to search for a value in a different spreadsheet.
    The second problem Is that I dont really know how to get it to search throught the entire column.
    The third problme is that my chain of hotkeys just results in closing the IE window for some reason.

    Any tips?

  2. #2
    Forum Contributor kalbasiatka's Avatar
    Join Date
    02-27-2016
    Location
    Brest, Belarus
    MS-Off Ver
    2021
    Posts
    224

    Re: How to search through specific webpages automatically using excel VBA

    what do we do with this?
    Not the most comfortable for parsing the page. Tags have no class, no ID. In fact there is a list: parameter / value.
    To learn how to take the information from the html page still need a little insight. Easy will not work.
    Last edited by kalbasiatka; 05-09-2016 at 02:13 PM.
    To do it for me and help me it is 2 different things!
    Sorry for my english, blame Google translator

  3. #3
    Forum Contributor
    Join Date
    04-28-2016
    Location
    Stavanger, Norway
    MS-Off Ver
    365
    Posts
    142

    Re: How to search through specific webpages automatically using excel VBA

    Quote Originally Posted by kalbasiatka View Post
    what do we do with this?
    Not the most comfortable for parsing the page. Tags have no class, no ID. In fact there is a list: parameter / value.
    To learn how to take the information from the html page still need a little insight. Easy will not work.
    Hi kalbasiatka

    Thanks for reply. Yesterday I asked how to copy the entire webpage as I thought I would get a better understanding of how it worked.
    Basically I would like to get the script to see if it can find any of the species names (that I got in a spreadsheet) on web pages like this;
    http://faktaark.naturbase.no/Vern?id=VV00001871

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copying or pulling data from multiple webpages automatically
    By projectatpel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2015, 03:18 PM
  2. Excel to onedrive to webpages
    By blacktrek in forum Excel General
    Replies: 0
    Last Post: 07-06-2015, 01:37 PM
  3. Extract a Specific data from multiple webpages to excel
    By pari9485 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2013, 01:10 PM
  4. excel sheets as webpages?
    By mikejones in forum Excel General
    Replies: 4
    Last Post: 02-23-2011, 10:45 AM
  5. Replies: 3
    Last Post: 05-05-2010, 09:15 PM
  6. Downloading Webpages to Excel
    By etrader in forum Excel General
    Replies: 5
    Last Post: 01-28-2010, 03:13 PM
  7. Automatically send an email from excel with specific data on specific date.
    By Angela1607 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-04-2009, 08:11 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1