All Questions
Tagged with web-scraping excel
19 questions
4
votes
2
answers
385
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
432
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
2
votes
1
answer
638
views
Python webscraper to get property info from Tripadvisor
I'm very much a beginner at programming, and hoping to get some advice!
I'm having some trouble with a tripadvisor scraper being slow, and have identified the part of my code that is taking a while. ...
- 23
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
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 ...
3
votes
2
answers
147
views
Writing and saving scraped documents in several sheets in an Excel file
I've written some code in Python for the purpose of scraping names and URLs from several links found in the left sided bar in a webpage and populate the data in several sheets (also giving each sheet ...
- 2,501
5
votes
0
answers
460
views
Scraper for parsing, downloading, and setting images beside each link in an Excel file
I've written a script in VBA which is able to parse image links from a website, download and store them in a local folder and finally set those images beside each link in an Excel file.
As the script ...
- 2,501
5
votes
1
answer
6k
views
Web scraping many URLs and writing to Excel file
I am using requests and BeautifulSoup to scrape 20000 URLs, each web page containing a table of information. Essentially each ...
- 51
2
votes
1
answer
425
views
Web scraping with VBA
I have this code that fetches rates from a website called X-Rates, and outputs to excel the monthly averages of a chosen country.
The code runs quite fast, but I still think there's improvements to ...
- 433
8
votes
2
answers
10k
views
Fast(er) web scraping with VBA
I have a code that fetches rates from a website called X-Rates, and outputs to excel the monthly averages of a chosen country.
The code runs quite fast, but I still think I could improve the code a ...
- 433
10
votes
2
answers
437
views
Financial Data From Webqueries in Excel
I'm new (to CR and to programming in general). I wrote my first VBA on Monday. This is my first working project. It Takes a bunch of financial data from a company called Financial Analytics and a ...
- 173