All Questions
24 questions
0
votes
0
answers
120
views
VBA webscraping - can't get innerText from class
i need to get copper price from website, but I get {{price}} instead of value.
What I'm doing incorrectly?
Thanks for help!
Option Explicit
Sub Macro1()
Const URL As String _
= "...
0
votes
1
answer
124
views
Using VBA to click on Javascript drop down
I am trying to figure out how to navigate through a JS dropdown menu with VBA. I have went through so many forum posts but I just cannot seem to figure this out. In the below website code the option I ...
- 35
1
vote
0
answers
81
views
web scraping from google page no longer returns anything
The below Excel vba code use to work and return the market cap, 52 week low and current price into my spreadsheet. It no longer does though and cannot work out why. Class names haven't changed but the ...
- 19
0
votes
0
answers
114
views
Web scraping in VBA using getElementsByClassName
I'm trying to scrape the price of the product on this page - "https://shop.rema1000.dk/varer/180122" - using VBA (I want a messageBox saying 8.95 or just 8 for a start). I've added Microsoft ...
0
votes
0
answers
108
views
Web Scraping with VBA: collection of strong elements
I would like to receive the following data for each player:
Purchase price (this value does not exist for each player!),
lowest price,
maximum price.
With my current coding I get as innertext all 3 ...
- 45
0
votes
1
answer
105
views
VBA Web Scraping- scraping a list of "hrefs"
I want to scrape a list of names which are included in a clickable link. However I don´t get a result. In a second step I would like to create per title a new tab.
It´s would be great if someone could ...
- 45
0
votes
1
answer
1k
views
VBA - WebScraping Get elements for classname for equal classNames
I want to extract two values (numbers and positions) per player which have an equal class name "text". I am currently unable to select the two correct values per player.
My problem is I ...
- 45
0
votes
1
answer
65
views
Retrieve element from page
I want to retrieve the IUPAC name of a chemical on https://echa.europa.eu/brief-profile/-/briefprofile/100.000.685
I'd like the printed result to return Benzene in this example.
The code below pulls ...
- 917
0
votes
1
answer
107
views
getElementsByClassName fails
I have below code but it fails and I am not sure why? The error is "Object variable or With block variable not set". Used to work previously not sure what changed. I have checked the class ...
0
votes
1
answer
279
views
VBA code error on pull or extract data from HTML website
I try to extract or pull data from HTML Element into Excel using VBA code:https://drive.google.com/file/d/1_fGBlOLzMxmV3r-WwC8klcBNB7wUuJN2/view?usp=sharing
My idea is to extract and pull the ...
- 19
0
votes
0
answers
86
views
Last row not correct / empty rows if entry exists in list
What is my goal:
Creating a list of entries with webScapring. The Scraper works fine and creates the list. It checks if a value exists. Only if the value not exists it will add to the list. The list ...
- 45
0
votes
2
answers
79
views
How to get value from website javascript?
On the webpage I have this:
<table class="infobox"><tr>
<td>
<table class="infobox-inner-table">
<tr class="infobox-heading">
<th id="infobox-quick-facts">Quick ...
- 380
0
votes
0
answers
53
views
vba getelelementbyclassname()
I'm beginner
I am studying about web scraping but, I have some problem i can't solve by myself.
I need your soultion.
I'm finding it that how to input getelementbytagname(a) in ...
1
vote
0
answers
150
views
Scraping data with VBA: Why can't I get access to html elements on certain webpages?
On certain webpages I cannot get access to HTML elements using VBA. What am I doing wrong? For example I have two different pages on the same website.
This code returns number of matches on the page.
...
- 53
1
vote
2
answers
494
views
Web scraping with getElementsByTagName()
I want to import restaurant data like Restaurant name, phone number, website & address to excel but unfortunately I am getting ads & garbage data. I have created a code using http://...
- 369