All Questions
40 questions
-3
votes
1
answer
381
views
Web Scrape Daily Treasury Rates
I have tried to write some VBA that scrapes a table from the URL below. I would like to create a macro that pulls in the data on a daily basis. Any help is much appreciated. Thank you
https://home....
0
votes
0
answers
796
views
How to extract company address from website
I have been browsing, trying and reading different codes from here but i can't get mine to work. What i am trying to do:
Browse a web which contains all information about the country's companies.
...
- 13
0
votes
1
answer
150
views
How to click HTML text with VBA
I'm writing a code to automatically fill some website with cells values:
Sub prueba()
Dim oIE As InternetExplorer: Set oIE = New InternetExplorer
Dim oDocument As HTMLDocument
Dim ECICOR As ...
- 27
1
vote
0
answers
87
views
The called object is disconnected from its clients in Excel VBA - Webscraping
I have a project at the company, where i should collect data from an intern website und write them down in excel. Therefore i tried web scraping with excel vba.
My Code looks like this:
Sub WebScr()
...
1
vote
1
answer
577
views
Scraping Data from Website using vba doesn´t work
I want to create a list of player names scraping a website. The Internet Explorer starts but I get an run time error "438" - Object does not support this property or method.
Structure of ...
- 45
2
votes
1
answer
315
views
VBA code to click on Excel icon from a webpage
I am trying to automate the click on Excel icon action to download Excel data using VBA from the following link Financial Statement of a Firm
The below is a html code for that Excel icon
<div ...
- 23
0
votes
1
answer
70
views
VBA Excel WebScraping
I have a project that I need to web scrape a different number of currencies values (around 15 of them). For one scraping this code below works fine, but how can I code this for consulting a lot of ...
- 1
1
vote
2
answers
264
views
How can i get a value with span tag in vba web scraping?
Im a begginer in web scraping, and this is my first project. Im trying to catch the value in the ADVFN website and pass it on to my sheet.
This is the link: https://br.advfn.com/bolsa-de-valores/bmf/...
- 11
0
votes
1
answer
53
views
Getting span id innertext
I am trying to get the value of <span id="Label1"> </span> innerText but not able to do it.
Set dados = oHtml.getElementsByClassName("Label1")(0).getElementsByTagName(&...
1
vote
1
answer
139
views
VBA Grab only Main Table from HTML Web Scrape. not the whole page
I have made the work by using excel copy and paste, not by web scraping properly. I am interested in capturing ONLY the data from the main table, but instead, I an getting everything in my response. ...
- 127
0
votes
1
answer
172
views
Extracting dynamic content Web scraping
I am aware that XMLHTTP only fetches the initial page source, it won't perform any dynamic updates. I don't want to try automating IE as its too slow.
I have attached the code below. I want to ...
- 51
1
vote
1
answer
85
views
VBA web scraping update
I have following code it:
open a webpage (amazon in this case)
click on all the products appearing on the page ( and open each product in new tab)
go through each open tab (from step 2), copy the "...
- 15
1
vote
3
answers
1k
views
Scraping current date from website using Excel VBA
Error
Librarys
I need the date of the current day. I do not want to place it inside a variable to be able to have it work, instead I would like that variable to be Date or in its default String.
Sub ...
- 325
0
votes
1
answer
291
views
'Busy' method of 'IUWebBrowser2' object failed
When I launch the site via my code, there is an error of type "method document of object iwebbrowser2 failed " at the level of my variable "oDoc"
Private Function CreerNavigateur(ByVal mails As ...
0
votes
1
answer
49
views
How to select each option in dropdown list and click a button (same origin policy issue - permission denied on the second iteration)
I need a code that loops through options in a < select > object on a web page, selects each option and clicks "Show" button to show some data related to the selected option. I started with this ...
- 5