Showing all 19 articles in this category.
VBA Code to Extract Data from Website to Excel To perform HTML screen scrapping or get webpage data into Excel using VBA code, read these easy tips. Programmers...
Export HTML Table to Excel - When Web query does not work To Import a HTML table in a web-page we can use, Web Query option in Excel to import it to Excel or Fr...
About Sitemap.xml Sitemap XML file is used by the search engines to find out the complete list of the pages of the website. Along with url link of the page, it ...
Excel VBA To Download File from Website URL In this article you will get VBA code to download file from any website URL. Consider your have a list of files to d...
Login Automatically into Social Media Networks in IE using Excel These days’ people spend too much time in Social Media Networks like Facebook, Twitter, and Goo...
Email Address Harvesting Software To collect Email Ids from website, use this Mass Email extractor or Email harvesting software. This is mainly used by marketti...
Web Scraping & Keywords Analysis Tool - SEO Get the Excel with VBA code for Scraping Keywords from Website to help in your SEO tasks. Search Engine Optimization...
Facebook Like Generator - Click all Like Button Do you get lot of interesting articles in your Facebook timeline. And you want to click 'Like' to your friends w...
Get Stock Quotes in Excel Use this simple technique to get free stock market data as an Excel stock price list. Have you been a stock market investor dumping a ...
Clear Cookies, Cache, Browsing History From Excel VBA delete cache, cookies, browsing history, temporary internet files used by IE or MSHML2 xmlhttp requests. T...
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 inv...
Extract Data From Website Using VBS (vbscript) To get website data to using vbscript (.vbs) file, we need to know 2 processes. First one is to extract HTML code...
How to scrape Website using Python BeautifulSoup? Applicable To: Python 2.7, 3 or above Data scraping is a method to get data from the websites for business pur...
VBA Web scraping with Internet Explorer Web scraping is the process of extracting data available to public. For example: You might want to extract stock histori...
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 bro...
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...
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 ...
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 weatherm...
Excel VBA to Automate Chrome using Selenium In this topic we will learn how to install Selenium library in Windows PC & initiate Chrome browser. Selenium is a f...