All Questions
Tagged with web-scraping vba
2,185
questions
-1
votes
0
answers
68
views
How do I pull data from a website to excel?
I tried the methods found on the internet. However, they did it either with "power query" or vba. "Power query" doesn't work for me. Those made with VBA do not fit this website. ...
0
votes
0
answers
44
views
Save a captcha image or take screenshot from website with VBA SeleniumBasic
I need to save a captcha image locally from a website but I haven't been able to do it. I have made some progress with my code but not completely.
I'm trying to take a screenshot of a website's ...
0
votes
0
answers
48
views
How can I correct this VBA to properly scrape the owner's name, given the property address in column A?
Hi I am trying use VBA to look property tax records off of. I'd like to return the owner of a property in column B, given the address is column A.
https://publictax.smith-county.com/Search/Results?
...
1
vote
0
answers
58
views
Excel VBA IE click open a new window and nothing happens, with no error too
Despite I'm just an entusiast absolutelly non pro, I'm using with moderate success an Excel vba code to fill some forms of an intranet company procedure written in html/java and download some data ...
0
votes
0
answers
59
views
Downloading multiple Excel files from webpage with VBA
As the title suggests I'd like to download multiple Excel's from the following site:
https://akk.hu/statistics/yields-indices-market-turnover/zero-coupon-yields
There is an Excel report button, which ...
0
votes
1
answer
61
views
excel vba web scraping with selenium multiple element problem
I want to scrape a table from chrome in excel vba with selenium, but there are several (currently 2) thead and tbody elements in the class. The code I'm currently using only takes the data from the ...
0
votes
1
answer
54
views
Object not set error when trying to change inner Text in website
I'm trying to do a simple macro with a site that formats/beautifies code,
1- Insert a text in input box to the left
2- Click "Beautify" button
3- Copy the result of output box to the right
...
0
votes
0
answers
26
views
VBA + Selenium How do i distinguish a checkbox and get value of the row that include checked checkbox
How do I get the data of the row that includes the checked checkbox? I have tried several ways to check if this checkbox is checked in VBA Excel but it doesn't work. Below is the HTML of the table, ...
0
votes
1
answer
56
views
Get parent element that contains string
I'm trying to get the class name of the div element that contains the information the calling areas between many div elements in the url. Since the div that contains the calling area information has ...
1
vote
1
answer
44
views
Follow up to Extract values from webpage table using VBA
Earlier today I asked the following question Extract values from webpage table using VBA. All answers gave me a way to access the data inside the HTML Object.
I want to do the same thing for another ...
-1
votes
3
answers
100
views
Extract values from webpage table using VBA
I need to extract some values from the table in the following website: https://www.anbima.com.br/informacoes/indicadores/.
I tried to use the solutions given in Extract table from webpage using VBA ...
0
votes
0
answers
29
views
VBA Error msg "This method cannot be called after the send method has been called" [duplicate]
I have couple of line codes of VBA and when running the code I get the Run-time error
'-2147024891 (80070005)' : Access is denied. When I click on debug, the error is on the code line XMLPage.send ...
0
votes
0
answers
51
views
Two scripts (Python and VBA) with the same logic produce different results when regex is implemented
I've created two scripts: one in Python and the other in VBA. Both scripts do the same thing but produce different results.
I've used a few links within the scripts to scrape a Facebook link from the ...
0
votes
0
answers
49
views
extract text in different td in multiple excel cells in vba selenium web scraping
good morning sir, in web scraping with vba using selenium I would like to divide the text as in the part of the html code that I have reported below, extracted from the page, I would like to extract ...
0
votes
0
answers
34
views
How to follow a search page when scaping using Excel VBA
I am making this call in Excel VBA
With CreateObject("MSXML2.XMLHTTP")
.Open "GET", "https://www.sloanex.com/catalogsearch/result/?q=" & SearchString, ...