+ Reply to Thread
Results 1 to 3 of 3

Webscraping, custom function

  1. #1
    Registered User
    Join Date
    12-23-2019
    Location
    Indianapolis
    MS-Off Ver
    2016
    Posts
    2

    Webscraping, custom function

    Hello All

    I am attempting to create a custom function that allows me to pull text from a certain website. Specifically, I am trying to create a database from webite call the boxrec, where I can add certain elements from the website, such as a boxers name, KO ratio, height, etc to a table. I watched a YouTube tutorial, but I am struggling to create a concatenated linked with specific parameters. I was not able to invoke the function based on my new parameter. In the video, I am having a problem specifically at around the 12:30 mark to the 15:00 minute mark. The website seems to not be the issue. I want to use the function to retrieve the boxers name, etc, as stated above. Thanks for anyone who can help. I have never used excel in this way.

    The file link is attached.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: Webscraping, custom function

    Hi,

    Maybe this gets you going, its very detailed for a start.

    https://www.youtube.com/watch?v=dShR33CdlY8
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

  3. #3
    Registered User
    Join Date
    12-23-2019
    Location
    Indianapolis
    MS-Off Ver
    2016
    Posts
    2

    Re: Webscraping, custom function

    Thanks for the help. However, I could not discern how to create a custom function from this video.

+ 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. Excel VBA Webscraping
    By Beddy Boy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2018, 07:35 AM
  2. VBA webscraping Yahoo finance
    By martijnrikkert in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2017, 08:46 AM
  3. Replies: 0
    Last Post: 11-20-2015, 12:34 PM
  4. Webscraping worksheet functions part 1
    By cyiangou in forum Tips and Tutorials
    Replies: 13
    Last Post: 08-17-2015, 11:33 AM
  5. WebScraping Data
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2015, 10:48 AM
  6. VBA for Webscraping Zillow
    By use_excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2014, 12:15 PM
  7. [SOLVED] Webscraping QueryTables to variable
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-28-2013, 01:37 AM

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