web scraping

0 I'm having trouble getting the value from an input field called "due date" Here is my HTML and VBA code. I resolved error 462, but I can't retrieve certain data. Actually I'm getting an error: Run-time error '91: Object variable or With block variable not set Error appears in any code starting...

Hello, I am having difficulties scraping webpage contents using SeleniumBasic, which I am new to. I can get a bunch of HTML language, but I cannot get the actual contents from the webpage. Below is the code I have, which requires the Selenium Type Library to run. I'm not sure what I am doing...

I have been working VBA to scrape website HTML code using the Microsoft HTML Object Library and the Microsoft Internet Controls Library. Now that support for Internet Explorer is being phased out, I am trying to switch my code over to scrape Google Chrome using the Selenium Type Library which is...

Hi everyone, As lacking of essential IT knowledge, I am looking for your kind help to make codes for getting data (final destination & ETA estimated time of arrival) from website tracking container numbers SEARATES (Online Container & Freight Tracking System – Searates.com) to Excel. I have...

Hello all, I'm trying to import some data for a fund listed on the Luxembourg SE. When I go to the site, I can insert the ISIN code, LU1883863935, in the search field and from there I can read the exchange symbol, 294814. As I'm trying to get the data into Excel, I can see when I use Inspect...

Hello :) I have this URL: Candriam Equities L Australia Class C AUD Cap, LU0078775011:AUD historical prices - FT.com. Using Chrome I can inspect the elements and there I need to be able to read the information about symbol=3280 from data-module-name="HistoricalPricesApp" I've tried various ways...

Hello, I need help trying to get the 1st line of the following 10-day forecast. Here is my code to get the forecast for Miami, FL on Weather.com. I am not able to get the current date or the first date in the summary. Please help. Thanks and take care. Sub MiamiWeather() Dim ieObj As...

Trying my hand at web-scraping again. I want to grab a specific text from a website, and to do so the first part of my code dumps the website's response into a cell of the worksheet. Here is the code: Sub Test() Dim URL As String Dim HTTPObject, HTMLObject As Object URL =...

I need some help from the smart guys here on the site. The code snippet below don't give any errors and it looks that it works fine, but the TD element collection stays empty and the innerText is empty too. That while the data are showing in a visual browser as You can see in the image below...

Hello Guys, i have below code that copy table on current webpage but when i change that page it not getting new table. note both the tables have same format, with little change in content, Dim i As SHDocVw.InternetExplorer Set i = New InternetExplorer Dim clipboard As MSForms.DataObject...

I am trying to find a good way to convert an HTML document to XML so I can use an Xpath expression for parsing. As a test I'd like to get this xpath expression to pull information from What Is My IP❓ Shows your real public IP address - IPv4 - IPv6 //*[@id="post-7"]/div[1]/div[1]/div/ul/li[2] So...

**Definitely a beginner. Please bear with me. First attempt at web scrapping.** I need the following URL to auto-login and retrieve a table from the website. I have pieced together VBA code from different websites to fill in the login information and hopefully pull a table but I am unable to...

I have used Excel VBA to navigate to a web site. I am trying to pull data from a specific part of the website. When I inspect the element the following is displayed: <span id="Status">Ready to Drop Ship</span> Does anyone know how to get the data "Ready to Drop Ship" from the above HTML code...

Hi, I am writing the following code which allows me to proceed to a website that I need to gather info from to then export into excel. I am very new to HTML web scraping with VBA and I am currently writing it line by line and testing it as I go. Sub GoToMarketingScents() 'navigate to...

Hi, I need to select option "Assigned to anyone" from below code. it looks like drop down list. HTML for it is as below <select class="form-control ng-pristine ng-untouched ng-valid ng-not-empty" ng-model="viewOptions.assignedToMe" ng-options="opt.value as opt.label for opt in...

Hi, I have been attempting to automate a web scraping process and I am needing to click a button on the web page; however, my object is constantly empty. Here is the html code: <div class="pull-right"> <button class="btn btn-primary js-export-customer"><span...

Hello everyone, I am trying to download a bunch of tables from a site (allowed by the site administrator). I can use the site's filters/search tools and get all my data by year on a web page. However I need 20 or so years worth of data, so I have to click on each year one by one to access the...

Hi all, My problem is two-fold. I have a worksheet already created that has a list of Football Leagues (in the rows), the columns hold the data. I have some code that fetches data from a website and populates this sheet (each row contains data corresponding to a league). It currently works, but...

Hi Team, I want to download a file to my local worksheet from the site: https://www.bseindia.com/corporates/List_Scrips.aspx# below is my code which I tried after doing some research. challenge is, how to avoid the page resubmit (retry, cancel warning window) secondly, I need to download the...

Hi guys, I'm trying to automate through vba a script that will follow a list of hyperlinks to Google search results and to copy the phone number listed for each link (phone numbers in google searches are listed on the right hand side). Example link showing the phone number on the right hand...