Skip to content
Primary Menu
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Web Scraping Browser Chrome Excel VBA Macro

Excel VBA Selenium Chrome – Easy Sample Code

August 13, 2025
Kumarapush

Install Excel VBA Selenium type library & launch Chrome browser for webdata extraction. Also other browsers like Firefox, Edge etc.,

Weather Python Web Enhancements Web Scraping

Get Current Weather in Python – Free Openweathermap Api

August 13, 2025
Kumarapush

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 […]

Browser JSON Web Enhancements Web Scraping

Current Local Weather Report in Excel

August 13, 2025
Kumarapush

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 […]

IP Address Network Web Scraping

VBA Get My Public IP Address

August 13, 2025
Kumarapush

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 […]

Hyperlinks Excel Network Web Scraping

Excel VBA Hyperlink Follow – URL within Macro

August 13, 2025
Kumarapush

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 […]

Web Scraping Excel VBA Macro Network Security

How to Web Scrape with VBA using IE & Parse HTML?

August 13, 2025
Kumarapush
0

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.

Web Scraping Python

How to Scrap Data from Website using Python?

August 13, 2025
Kumarapush
0

Learn how to use BeautifulSoup with Python to scrape website & then parse the HTML from the page.

Web Scraping Excel VBA Macro HTML / Javascript

VBScript Extract Data – Xmlhttp Web Scrape – Parse HTML

August 13, 2025
Kumarapush
0

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.

Web Scraping Excel VBA Macro Finance

How to Get Historical Stock Quotes In Excel – Google Finance

August 13, 2025
Kumarapush
3

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 Macro System Control Web Scraping Windows API

Excel VBA Clear Cache – IE browser and xmlhttp requests

August 13, 2025
Kumarapush
0

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 […]

Posts pagination

1 2 Next
Excel VBA Macro Tricks
  • Launch List of Application – Batch Execution
  • Excel Instant Messenger – Microsoft Office Communicator API Library
  • Login to Facebook, Twitter, Google+ in IE from Excel
  • Hyperlinks Index – Get all links with address, cell – Whole Workbook
  • How to Unzip file using VBA – Excel Macro?
  • VBA get Path to Default Temporary folder
  • Convert a Formatted Cell in Excel into HTML Tag using VBA
  • Export Email Data To Excel With Mailparser
  • Excel VBA For each cell in Range – Direct method
  • How to Delete Blank Rows in Excel – Remove Empty Rows – 3 Easy Tips
  • VBA Code – Create Index of Worksheets – with Links to each Sheet
  • Merge Multiple Excel Files to One – Selected Sheets
  • Convert CSV to Vcard File – Download Converter App
  • Removing Empty Folder is Now Easy – Get Folder List with Size
  • Open Text File – Read Write File Operations – VBA, Python, VBS, C, C++, DOS
Browser Tricks
  • New Android Update – View/Send SMS messages from any PC Web browser
  • JavaScript Browser Detection
  • How to enable dark mode in Firefox browser?
  • Current Local Weather Report in Excel
  • How to Save Web Page as PDF File – No Plugins Required
Chrome Tricks
  • How to enable JavaScript in my browser? – Chrome,Firefox,IE,Opera,Safari
  • How to Save Web Page as PDF File – No Plugins Required
  • How to enable Google Chrome Dark Mode or Dark Theme?
  • Creating Folders Using Python: A Simple Guide
  • A Simple Guide to Copying Excel Sheets
  • Retrieve All Files in a Directory using Python
  • Creating Folders in Outlook: A Guide
  • Chandrayaan 3 Live Stream Today – Vikram Lander
  • Creating Folders Using Python: A Simple Guide
    As the world of technology continues to advance, it becomes evident that the ability to manipulate, create, and manage digital spaces is of utmost importance. Python programming language is among the most powerful tools capable of such feats. This exciting exploration commences with an introduction to Python, providing essential knowledge […]
  • A Simple Guide to Copying Excel Sheets
    Navigating the intricate landscape of Microsoft Excel can often seem like a daunting task. This software, with its abundance of features, functions, and commands, requires a keen understanding to fully utilize its potential. Whether you’re an industry expert or a novice user, mastering the art of manipulating Excel sheets is […]
  • Retrieve All Files in a Directory using Python
    In our digitally driven world, where data processing and management are integral to many industries, the ability to work with Python has become an invaluable skill. This language, particularly in relation to file and directory manipulation, grapples with the rapid growth of data and its intricate handling. With its intuitive […]
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Copyright All rights reserved