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

May 08, 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

May 08, 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

May 08, 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

May 08, 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

May 08, 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?

May 08, 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?

May 08, 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

May 08, 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

May 08, 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

May 08, 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
  • VBA Hello World – Excel Macro – For Beginners
  • Excel VBA Delete Folder if Exists
  • Excel VBA Text To Speech – Voice Application Activation
  • How To Speed Up Excel VBA Macro Execution Time – Optimize?
  • Convert a Formatted Cell in Excel into HTML Tag using VBA
  • VBA Macro – Choose Outlook Email Account – To Send Mass Mail
  • Excel Vba RGB to Hex,Long – Hex to Rgb,Long – Color Code Conversions
  • How to Create a Macro in Excel 2010, 2007 & Above
  • How to Add Sheets in Excel – VBA Create Worksheet – Dynamic Spreadsheet
  • VBA Combo box Add Items – from Excel Range or Array
  • VBA Macro Import – Read XML File into Excel – 5 Easy Tips
  • Copy Excel Chart in Powerpoint – Macro VBA pastespecial
  • Application Monitor – Manage & Terminate – Tasks Manager
  • How to create Drop down data validation list in Excel?
  • VBA Copy File to Folder
Browser Tricks
  • How to enable dark mode in Firefox browser?
  • How to Save Web Page as PDF File – No Plugins Required
  • New Android Update – View/Send SMS messages from any PC Web browser
  • How to enable JavaScript in my browser? – Chrome,Firefox,IE,Opera,Safari
  • Current Local Weather Report in Excel
Chrome Tricks
  • How to enable Google Chrome Dark Mode or Dark Theme?
  • How to Save Web Page as PDF File – No Plugins Required
  • How to enable JavaScript in my browser? – Chrome,Firefox,IE,Opera,Safari
  • 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