+ Reply to Thread
Results 1 to 1 of 1

How to get information from a website with the click of a button

  1. #1
    Registered User
    Join Date
    07-12-2019
    Location
    Rock Hill, South Carolina
    MS-Off Ver
    Office 365
    Posts
    29

    How to get information from a website with the click of a button

    Hello everyone!

    I'm still somewhat new at all this vba stuff. I'm a super quick learner, and can usually look at what someone's done and figure it out. But I'm stumped here.


    My ultimate goal is to write something that will allow me to enter a search term and get back relevant information without having to leave excel. The website I want to get the information from is a website that requires a username and password.

    I've been trying to reverse engineer something based on the vba in a document I got from a coworker forever ago, but I honestly can't figure it out, and I'm not even sure where to start.

    In the document I attached, you can enter patent numbers and then click the USPTO button. It will then give you the inventors and the issue date of the patent. I'd like to do something similar. I'd like to be able to enter a drug name via the website I need to use and have it return the results that are over 70%.
    That might not make a lot of sense, but that is the ultimate goal.

    Does anyone have any suggestions on where to start? Or is there a book out there that might be helpful in finding a place to start?

    Thanks for any help you can give!!!
    Attached Files Attached Files

+ 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. [SOLVED] website login button click
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 02-06-2018, 06:26 AM
  2. Website Script to click button on Website and export file to directory?
    By stangz71 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2017, 03:55 PM
  3. Need to click on search button in a website using vba.
    By Tonmoy Roy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2017, 11:53 PM
  4. Get Data from a Website - Unable to click Button
    By karan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2016, 04:45 PM
  5. VBA (Excel) code to click button on website
    By SteveCole in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2013, 05:05 AM
  6. To Click on log in button of a website
    By sushil10s in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 01:20 AM
  7. Click button on website from VBA
    By davegugg in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-12-2009, 05:25 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