+ Reply to Thread
Results 1 to 5 of 5

Using VBA to find and click a link on a web page then download PDF

  1. #1
    Registered User
    Join Date
    11-06-2019
    Location
    Portland
    MS-Off Ver
    10
    Posts
    4

    Using VBA to find and click a link on a web page then download PDF

    Hey all,

    Nutshell of needs:
    Support with two things 1)code to click a specific link on a website and 2)downloading the PDF on the page it loads.

    As of right now, I can get to the page I want, but I can't seem to write code that will click the link I need. Second, which I have only done a little research on, is now that I'm on the webpage, writing code to download the PDF. Any help is greatly appreciated!!

    Couple notes: The link in my code seems to be only temporary for the session when you first do the search, so you will need to start with the "property search" link below and enter the parcel number as well. This will produce a new unique URL that you will need to replace my link in my code for yours to work. Once you do this you seem to be able to close out and re-use your new link.

    SUPPORT INFO:
    multcoproptax.com/Property-Search
    Parcel Number: R246326

    Thanks all,


    Please Login or Register  to view this content.
    Last edited by Leith Ross; 11-06-2019 at 07:01 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Using VBA to find and click a link on a web page then download PDF

    Hello tmunee,

    Welcome to the forum!

    When I click the export button on the web page manually, I get the following error: A critical error has occurred. Please check the Event Viewer for further details.

    So, two things come to mind, either the server is down or I need to be login in to the site.

    Are you experiencing any issues?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    11-06-2019
    Location
    Portland
    MS-Off Ver
    10
    Posts
    4

    Re: Using VBA to find and click a link on a web page then download PDF

    Hey Leith! Thanks for the quick reply and greeting! I have actually been using this site for years, but this is my first post

    Question regarding your post: Are you getting the error on the initial search page (multcoproptax.com/Property-Search) or when you are on the "Bills" tab and clicking "2019" hyperlink to see the PDF?

    I just tested both, and mine seems to be OK.

    Thanks again for the prompt reply!

  4. #4
    Registered User
    Join Date
    11-06-2019
    Location
    Portland
    MS-Off Ver
    10
    Posts
    4

    Re: Using VBA to find and click a link on a web page then download PDF

    Hey Leith,

    I was able to reproduce the error you got:

    2019-11-07.png

    This occurs when you try to go directly to the web address and not searching for it first to get that custom session started. If you start at: "multcoproptax.com/Property-Search" and search for Parcel Number: R246326. That should work for you to see the data. From there, take that new URL and put it into my code and it should get you to the point where I'm stuck and it wont "click" 2019..

    There is no logins - this is all public records.

    Let me know if that works for you!

    Thanks!!

  5. #5
    Registered User
    Join Date
    11-06-2019
    Location
    Portland
    MS-Off Ver
    10
    Posts
    4

    Re: Using VBA to find and click a link on a web page then download PDF

    Hello all, just wanted to see if there was anyone that could give me a little help with this project.

    Thank you all!

+ 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. how to click any link in a website and extracting the new link and text in our excel sheet
    By prahladsingh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2016, 11:55 AM
  2. VBA: IE.Application - STUCK - How to click on link in Web page?
    By alacey425 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2015, 01:22 AM
  3. right click and open link on web page
    By JustinN1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2014, 10:40 AM
  4. Macro to download a file by click a button on internet link
    By NoreenDeasy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2014, 12:19 PM
  5. [SOLVED] How to create a link, to send via email one specific page of a work book with a click??
    By jetlee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-28-2013, 02:32 PM
  6. Click cell, link to a page, filter and sort data
    By spreaderman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2012, 03:47 AM
  7. [SOLVED] Help with Click link, Find, Paste (Excel to Web back to Excel)
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2005, 04:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1