All Questions
Tagged with web-scraping vba
2,204 questions
0
votes
0
answers
149
views
Extract values from dynamic table using VBA
I would like to extract data from a few tables from the following website:
https://www2.bmf.com.br/pages/portal/bmfbovespa/boletim1/SistemaPregao1.asp?pagetype=pop&caminho=Resumo%20Estat%EDstico%...
- 177
0
votes
1
answer
56
views
Python scraper not returning value to Excel
I have a Python webscraper that pulls a specific value every 1 second. The target website it AJAXed, so I'm not hitting it with too many requests.
This is the Python code:
import time
import logging
...
- 1,136
0
votes
1
answer
108
views
Webscraping dynamic content using Excel VBA
I need to monitor the content of some webpages (to see if any information posted on them has changed). For various reasons, I have to use an Excel spreadsheet to do this, so that limits me to using ...
- 1,016
0
votes
1
answer
44
views
VBA scrape URL with nested DIV's
I've been following this This Tutorial to scrape data from a URL as it matches my need pretty closely (3 div's deep). Unfortunately where StackOverflow no longer supports IE I can't test the Tutorial'...
- 704
0
votes
1
answer
118
views
Get inner text of multiple <p> with its corresponding <h2>?
I have some VBA coding experience, but I am still an newbie in Web Scraping.
I face the following problem:
I am trying to scrape the article text by getting all the <p> tags that come after <...
1
vote
1
answer
41
views
Access VBA MSHTML document with scripts loads slowly
Why would a local html file with remote scripts and css links take a long time to load
For example,
<script src="example.com/ajax/font.js" type="123-text/javascript"></...
user4831894
0
votes
1
answer
66
views
Excel VBA : Element not found ---> NoSuchElementError
I am trying to automate web browsing using Excel VBA, with Seleinum Web driver. I am in first step in navigating the website, and I stuck. I am not able to find the element for the username and ...
0
votes
0
answers
32
views
Structuring webscraping algorithm with many unknowns ahead
This is conceptual in nature.
Currently I am gathering information on a variety of fasteners from a vendors website.
I have created a code which works okay for one type of fastener which produces 2000 ...
- 13
1
vote
2
answers
116
views
XMLHTTPRequest always returns "Page not found"
Premise
There is this website I'm trying to scrape.
https://pb.nalog.ru/
If you put organization ID in a search bar, and press "Искать", it redirects you to a separate page with base url of ...
- 1,149
1
vote
0
answers
66
views
How to Login to a Website that is using an Angular ng-model form class
I am trying to use VBA to login to a website that is local to my network (http://192.168.0.160/wespjs/index.html#/login). I'd like to navigate to the website on my own, and then use a simple command ...
- 11
0
votes
1
answer
76
views
Scraping prices from a webpage (VBA macro)
Simply said, I have a big macro which scrapes prices from a number of our customers and their eshops. Now, my macro works on every single one of them with one exception. I have been trying to make it ...
0
votes
0
answers
49
views
Extract data from web that isn't detected as a table
I'm struggling getting data from the web to Excel, as it isn't detected as a table. There was a similar case reported (How to get data to excel from web that the data is not in a table?), but I have ...
0
votes
0
answers
58
views
Run-time error -2147023170 (800706be): Automation error, the remote procedure call failed
I am getting this above-mentioned error on running. The purpose of this code is to take values from an Excel sheet and put two values from the sheet into the website then extract results from web into ...
0
votes
0
answers
83
views
Need VBA code to retrieve ALL data from a webpage
I’m trying to retrieve a list of attendees to an event on a webpage. If I use a browser, to the webpage, right click, and choose View Page Source I can see the names of the attendees.
I need to do ...
- 3
0
votes
2
answers
113
views
How to force scrolling down in a browser page using Microsoft.XMLHTTP?
With this code I can go to this webpage and capture the first 10 events. The problem is that there are 30+ events and I need to capture them all. When you are scrolling manually with the mouse ...
- 3