Install Excel VBA Selenium type library & launch Chrome browser for webdata extraction. Also other browsers like Firefox, Edge etc.,
Get Current Weather in Python – Free Openweathermap Api
October 25, 2024
Python – Weather Report for any City There is a similar article to this in which the weather report is obtained using Excel Vba code. To use this open weathermap Api , you have to first register with your email and get the AppId key. They provide a free limited […]
Current Local Weather Report in Excel
October 25, 2024
City Weather Report in Excel Excel Vba code in this page gets current local weather report using free api from openweathermap. To use this code, you need these things in advance: API key from openweathermap Accepted City Names Register with you email in the api provider website & they will […]
VBA Get My Public IP Address
October 25, 2024
What is my Public IP Address? There are no direct methods to get public ip address in VBA. This has to be done by using a web service using below steps: Open IE Explorer from VBA Code. Navigate to this page -> What is my Ip? Wait for page to […]
Excel VBA Hyperlink Follow – URL within Macro
October 25, 2024
How to Click Hyperlink in Excel with VBA Macro? There are 2 methods available to click a hyperlink in Excel. Both the methods do open the URL in the default browser or open the corresponding file in the default application. Here is the code demonstrates both methods. Sub follow_hyperlink() ‘Follow […]
How to Web Scrape with VBA using IE & Parse HTML?
Get VBA code to web scrape using IE & then parse HTML data from website. The extracted website data is Parsed within Excel VBA code itself.
How to Scrap Data from Website using Python?
Learn how to use BeautifulSoup with Python to scrape website & then parse the HTML from the page.
VBScript Extract Data – Xmlhttp Web Scrape – Parse HTML
Get code to Extract data from website using vbscript. Also the code can be used to parse the html data obtained from the website using vbs parser.
How to Get Historical Stock Quotes In Excel – Google Finance
Get Historical Stock Quotes – Google Finance Historical Stock Quotes are required as a first data item when you considering buying a stock. Lets say you are investigating GOOG stock listed in the NASDAQ Stock Exchange. You can download the Historical Stock Quotes to Excel using Google Finance with the […]
Excel VBA Clear Cache – IE browser and xmlhttp requests
Clear Cookies, Cache, Browsing History From Excel VBA delete cache, cookies, browsing history, temporary internet files used by IE or MSHML2 xmlhttp requests. This method is applicable to IE browser only. To delete browser cache, cookies, temporary files of other browser like Chrome or Firefox, use the manual methods discussed […]