All Questions
Tagged with web-scraping vba
35 questions
4
votes
2
answers
384
views
Scraping campsite availability from a webpage using vba with selenium
I wrote some code to extract the information from a table, but it takes an extremely long time.
The table is in the format of a calendar.
I need the information on an Excel sheet with column 1 as the ...
- 41
2
votes
0
answers
608
views
My first vba-selenium code
I have been obtaining financial information on an annuity I have which is invested in multiple funds which are proprietary to the insurance company.
The asset value is not available other than on ...
- 121
2
votes
0
answers
431
views
How to speed up the VBA scraping process
I want to scrape 25000 addresses using Column A cell values as search strings. I'm using the following code, it is working fine but it's too slow to extract 25000 results. Is there any way to speed up ...
- 21
2
votes
1
answer
1k
views
Excel VBA code that displays a 14 day weather forecast
I am trying to see if anyone can help me in making this Excel VBA code a little faster in rendering the data from the weather site I am using. Maybe instead of getting all 14 days it includes in the ...
- 31
4
votes
0
answers
96
views
Scraping and filling out a time-off request
In my ongoing quest to automate everything I have to do at my job, I've decided to learn how to do webscraping with VBA. I wanted to start with something easy, so the following simply fills out a ...
- 133
1
vote
1
answer
596
views
Downloading latest monthly files VBA - HTML [closed]
Situation:
I am trying to download files, for the latest available month, from the webpage NHS Delayed Transfers of Care. I am unable to locate these files, within the HTML, with confidence that my ...
- 385
3
votes
1
answer
2k
views
Web scraping data from US postal zip codes
Web scraping county, population and median home value from United States postal zip codes.
I switched from using InternetExplorer.Application to New MSXML2....
- 181
1
vote
1
answer
5k
views
Handling lazy-loading webpages using vba
After a long try I've been able to create a script in vba which can successfully handle webpages with lazy-load. It can reach the bottom of a slow loading webpage if the hardcoded number of the loop ...
- 2,501
1
vote
1
answer
142
views
Parsing a website, saving tables in Excel
This program parses a website. The program works well, but is too long. I want to simplify/speed it up.
How program works:
First , the program finds needed hyperlink in Excel
Then by the hyperlink , ...
- 11
4
votes
2
answers
6k
views
Scraping webpage elements with VBA script
With some help I've put together a macro to scrape webpage elements by tag ID from URLs (indicated in column A of an Excel sheet) and insert the text into columns B, C and D. The code loops from 1st ...
2
votes
1
answer
602
views
A recursive web-crawler created using vba
I had a desire to make a recursive web crawler in vba. As I don't have much knowledge on vba programming, so it took me a while to understand how the pattern might be. Finally, I've created one. The ...
- 2,501
2
votes
1
answer
2k
views
Web scraping using proxy in vba
I've written a script in vba to parse movie names and year from a torrent site. The script is doing just awesome. Although the scraper is leaving no room for complaint, I'm still dubious about how the ...
- 2,501
2
votes
1
answer
3k
views
Making a dynamic parser to collect data from a javascript enabled webpage
I've written a scraper in VBA in combination with selenium to parse product names and prices from a javascript enabled webpage. The thing is that I just used selenium to get the page source (as it was ...
- 2,501
3
votes
0
answers
5k
views
Fetching data from a website using "POST" request
I've written some code in vba for the purpose of making twofold "POST" requests to get to the destination page and harvest name and address from there. There are two types of structures within which ...
- 2,501
2
votes
1
answer
135
views
Scraping information from a webpage not knowing it's last page number
I've written some code in vba to scrape names and phone numbers from a webpage that has spread across some pages I don't wish to know of. The main interesting thing with this scraper is that It only ...
- 2,501