+ Reply to Thread
Results 1 to 4 of 4

Macro to obtain values from a web page associated to an entered number

  1. 05-25-2019, 03:21 PM #1
    Aykko
    Aykko is offline
    Registered User
    Join Date
    05-25-2019
    Location
    Quebec, Canada
    MS-Off Ver
    Office 365
    Posts
    2

    Macro to obtain values from a web page associated to an entered number

    I would like to obtain values from a page like that one :
    cdn.ca/francais/query/detail_ge.php?breed=HO&country=CAN&***=F&regnum=110831500

    Add in www at the beginning, i was not allowed to place the link...

    I would like it to go as following, I would type in the last 4 digits of the url in the first row, and it would get the values marked in the document on the lines under it(without any suffix to them), example is in the document

    I tried to do it myself but all the examples I found were taking a value in the first layers of the html and I was not able to find how to get the values I wanted.

    Any help is welcome, I included some more details in the file
    Thanks
    Attached Files Attached Files
    Last edited by Aykko; 05-27-2019 at 10:28 AM. Reason: Including a file
    Reply With QuoteRegister To Reply
  2. 05-26-2019, 10:04 AM #2
    Keebellah
    Keebellah is offline
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Macro to obtain values from a web page associated to an entered number

    Nobody will be ablo to do anything with an image file, how about a sample file WITH the macro's?
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you
    Reply With QuoteRegister To Reply
  3. 05-29-2019, 07:34 PM #3
    rino.rioux.702
    rino.rioux.702 is offline
    Registered User
    Join Date
    03-27-2015
    Posts
    6

    Re: Macro to obtain values from a web page associated to an entered number

    Hi Aykko,

    The web page has a complex structure to extract the data from it. The web page contains table that has many level of sub-table.

    I rewrite your macro to call a GetDataFromTable that will interest you.

    See the attached file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 06-15-2019, 02:14 PM #4
    Aykko
    Aykko is offline
    Registered User
    Join Date
    05-25-2019
    Location
    Quebec, Canada
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Macro to obtain values from a web page associated to an entered number

    Thanks Rino, I tested it during the last weeks and it works perfectly, thanks again
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using VBA w/ HTML: I'd like to scan a page to obtain all fields/variables I can write to
    By joe31623 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2016, 10:43 PM
  2. Supressing zeros in number columns when no decimal values are entered
    By KJay in forum Excel General
    Replies: 10
    Last Post: 09-02-2015, 07:46 PM
  3. [Macro] Enter multiple set of values to obtain result in a certain way in excel
    By chocochoco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2013, 03:13 AM
  4. [SOLVED] I need help on moving a row to a diffrent page if a number is entered in cell
    By icevinson in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 03-18-2013, 08:03 AM
  5. [SOLVED] Run a macro depending on number entered into cell?
    By Margate in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-04-2013, 08:21 PM
  6. Obtain report automatically base on the data on first page
    By sfs4c03 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2013, 08:44 PM
  7. How to obtain progressive values from a larger range of values X/Y
    By Joah in forum Excel General
    Replies: 0
    Last Post: 06-14-2012, 09:59 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1