Hi, I am Arun Banik
I publish practical, example-driven coding tutorials for JavaScript, SQL, Excel, Python, and web developers. ☕🍃

How to Read data from a Closed Excel file Without actually Opening it using VBA?
One Simple Method

I have shared a simple example (a Macro) explaining how to use ADO to read data from a closed Excel file or workbook without actually opening it.

Best JavaScript Methods for Efficiently Loading Multiple Images After Page Load

The best way to load multiple images after the page has loaded in JavaScript is to use lazy loading or asynchronous image loading.

How to Create a Progress Bar in Excel Using VBA: Two Easy Methods

Want to enhance your Excel workflow with a dynamic progress bar? In this tutorial, I'll walk you through two effective methods to display a progress bar in your Excel worksheet using VBA. Whether you're tracking task completion or visualizing macro execution, these techniques will add a professional touch to your spreadsheets.

Automate Your Celebrations: Send Emails on Special Occasions with Excel

In this post I'll show you how to send emails automatically from Excel on special occasions like christmas based on time and date using a simple macro.

A Simple JavaScript Code to Easily Detect Bots on Your Website

Learn how to detect bots on your website with a simple JavaScript snippet that flags users as suspicious if no mouse movement, keypress, or scroll activity is detected.

Top SQL Server Aggregate Functions Explained with Examples

Discover the most commonly used aggregate functions in SQL Server, including SUM(), COUNT(), AVG(), and more.

Understanding Triadic Colors: A Complete Guide for Beginners and Designers

In this post you will learn what triadic colors are and how to use them effectively in design. This beginner to mid level guide explains triadic color harmony with tips, examples, and easy tools for building color palettes.

What Are Complementary Colors and Why They Work?

In this post, we'll explore what complementary colors are, why they work so well, how to use them effectively with real world examples

What are Alternatives to Media Queries for Responsive Design?

Discover alternatives to media queries like container queries and intrinsic design for modern responsive layouts.

How to Read XML Files with async/await in Node.js and Render Them in the Browser

Learn how to read files asynchronously in Node.js using async/await. This beginner-friendly tutorial covers reading text files, handling errors, and writing clean, modern JavaScript code.

Learn How to Fetch and Parse XML Data from a Web URL in Python

Here in this article I am going to show you how to fetch and process data from an XML file in Python. I am using VS-Code to run (execute) the example.

Build a real-time WebSocket connection with Node.js and JavaScript - Perfect for Beginners.

Build a real-time WebSocket connection with Node.js and JavaScript, perfect for beginners. Includes server and client code for instant browser-server messaging.

How to Build a Word Cloud (with tooltip) from Textarea Input Using JavaScript

Create a word cloud from textarea input using JavaScript. Parse text, count word frequency, and visualize it with interactive tooltips—all in a few lines of code.

Dynamically Add Dropdowns and Checkboxes in Excel UserForms Using VBA (2025 Guide to Events)

Learn how to add dynamic controls and events in Excel UserForms using VBA. A beginner-friendly 2025 guide for smarter automation and form design.

Implement Cell Triggered Column Visibility in Excel Using VBA Events

Discover how to use a VBA macro in Excel to hide or show columns with a simple cell click. Create interactive spreadsheets with this easy-to-follow tutorial.

Fetch and Display Paginated Data in an HTML Table Using Web API with Async/Await

Efficiently load and display paginated data in an HTML table using Web API and async/await. A step-by-step guide for modern web developers.

What Copilot Notebook and My Fancy Notepad Have in Common?

Discover how Copilot Notebook and My Fancy Notepad deliver simple, accessible, and distraction-free writing in your browser.

Automate Outlook: Send Emails with Attachments from Excel Using VBA (2025 Guide)

In this article, I am going to show you how to send email with attachments from an Excel file using VBA macro and Office Outlook.

Stylish CSS Spinner Effects: Lightweight, Pure CSS Loaders for Modern Web Design

Discover 3 stylish CSS spinner effects—bouncing dots, glowing circle, and twisting square. Lightweight, pure CSS loaders for modern web design.

Mastering Word Counting for Writers: The Ultimate Guide to Using The Word Counter Tool

In the world of writing, whether for academic papers, blogs, novels, or business communications, precision matters. This is where The Word Counter tool comes in as an indispensable resource.

How to Use SQL Server Triggers to Block Default 1900-01-01 Dates?

Use SQL Server triggers to block default date values like 1900-01-01 and ensure clean, accurate data entries. Learn how with this quick guide.

Blockchain Basics: A Beginners Guide to the Future of Digital Trust

Explore the foundational concepts of blockchain technology in this beginner-friendly guide, unraveling how it works, why it matters, and how it's revolutionizing trust in the digital age.

How to Use JavaScript to Reduce Bounce Rate and Improve User Retention?

Learn how to use JavaScript to prevent users from exiting your web page too quickly. Boost engagement, reduce bounce rate, and improve your Google Analytics 4 tracking with smart exit-intent strategies.

Create a Responsive Card Layout Using CSS Grid with Images and Flexible Design

In this guide, you'll learn how to design responsive image cards with CSS Grid. Whether you're building a portfolio or a product gallery, this layout ensures your content looks stunning across all devices.

Introducing Gemini CLI: Google's Powerful New Open-Source AI Agent for Your Terminal

Gemini CLI lets you use Google's Gemini 2.5 Pro model from the command line. Learn how it is useful for developers.

What is the formula in Excel to count how many times a particular word occured in a range?

You can use the COUNTIF() function in Excel to count number of occurrences of a particular word in a range.

Let us assume, I have a list of different types of birds in the 2nd column in my Excel worksheet. I want to know how many times a bird of type "Dove" or "Sparrow" is entered in the list. Check the formula.

HTML rel='noopener noreferrer' Tag. What does it mean?

The rel="noopener noreferrer" is used to enhance security and privacy when opening links in a browsers tab or a new window.

How to Center Align Content inside DIV using CSS? - Three simple methods.

To center align contents inside a DIV using CSS, you can use different approaches depending on your specific needs. I have shared three simple methods here.

What is Dynamic PIVOT in SQL Server and how does it enhance data transformation?

Dynamic PIVOT is a technique in SQL that allows you to transform rows into columns dynamically, without hardcoding the column names. This is useful when the column values are not known in advance or may change over time.

3 Effective Methods to Extract Data from Another Excel Workbook Using VBA

I have shared three simple methods here, which shows how to pull or read data, as it is, from another Excel workbook, in your computer or from a remote computer.

What is the Purpose of Minification in Web Development?

HTML Minifier tools play a vital role in optimizing web performance by reducing the size of HTML files without compromising functionality.

Best 6 Online Bulk Image Resizers for Fast Optimization & Compression

In this guide, we’ll explore the top 6 online bulk image resizer tools that help you resize, compress, and enhance images effortlessly.

How to Export Table Data (as it is) from Multiple Excel Sheets to PowerPoint Using VBA?

In this article, I'll guide you through exporting table data from multiple sheets in Excel to PowerPoint efficiently using VBA.

How to Check Grammar in Text Using a Simple JavaScript Code?

I am sharing a simple JavaScript code snippet here that performs basic grammar checking using the LanguageTool API.

How to Build a Simple Chat Application Using jQuery?

A simple chat application using jQuery's text() method enables dynamic messaging by efficiently updating text-based content without modifying HTML structure.

10 Common performance issues in JavaScript that you should avoid

This guide highlights the most prevalent JavaScript performance pitfalls and provides insights on how to avoid them.

Practical Uses of an HTML Minifier: Optimize Code for Better Performance

HTML Minifier tools play a vital role in optimizing web performance by reducing the size of HTML files without compromising functionality.

How you can fetch real-time stock quotes directly into your Excel worksheet using VBA, updated every few seconds.

If you are still actively involved in stock market investments and use Excel to manage your portfolio, here’s a handy example

SQL Server - How does COALESCE compare to the ISNULL function?

Both COALESCE and ISNULL are SQL functions used to handle null values, but they differ in their purpose and functionality.

Merge and Combine Cells in Excel Without Losing Data: A Step-by-Step VBA Guide

In this article, I have share a simple VBA macro to merge and combine cells in Excel without losing any data.

How to get a Random word from a list of words in Python?

I am sharing a simple code snippet in Python here in this article that shows how to get a random word from a list of given words.

How to Count Total Number of Words in Excel cells and Ranges using a Formula?

Here in this article, I am going to share a simple formula to count the total number of words in cells.

How to Retrieve Last 5 Minutes of Data in SQL Server: 3 Efficient Query Examples

In this article I am going to show you 3 different SQL Queries to get the last 5 minutes data in SQl Server.

Extract File Names from File Paths in Excel using this simple macro

Sharing a simple macro in Excel that extract filenames from filepaths.

How to Automatically Add One Month from Previous Date in Excel

In Excel, you can use the EDate() method to automatically add one month from the previous date or increment the previous date by one month.

How to use Excel TEXTJOIN() function in a formula to remove parentheses and the text within them?

In this article, I will introduce a more advanced formula to remove parentheses and the text within them.

How to Generate Random Words using JavaScript?

In this article I am sharing a simple JavaScript code snippet to gererate random English words. The words are defined in an array.

How to Split a string into Multiple Lines on a Web page using JavaScript

I've have shared three different methods to split a string into multiple lines using JavaScript

How to capture Image from Webcam and add it to an HTML table?

The examples here demonstrate how easily you can capture an image from your webcam and add it to a table using JavaScript.

How to use Power Query in Excel to connect SQL Server and import data into your worksheet?

In this article I am showing how to user Power Query to connect SQL Server database and retrieve data into Excel worksheet.

How to use filter() to find words in an array that starts with a letter?

Shared few examples here that shows how to use the filter() function in JavaScript to find words that starts with a letter.

How to Embed YouTube Video in HTML without IFrame

In this article I have explained with examples how to embed YouTube videos in a web page without iframe.

JavaScript - How to use array.reduce() and map() Methods together for efficient data manipulation

VBA Tutorial: How to read multiple excel files and merge data into separate worksheets in a single file?

Here in this article I’ll show you how to read multiple excel files or workbooks and merge the data accross multiple worksheet in a single file using VBA

Asp.Net Web Service - How to return a String Response to an Ajax call instead of XML?

In this article I am going to show you how to configure an Asp.Net web service to return a string response instead of xml.

How to use Highcharts API to create dynamic and animated charts with data from external JSON file?

Highcharts is a pure JavaScript library, which provides easy to use methods and properties to create interactive and animated charts for your websites and web applications.

How to create a "simple" Data Entry Form in Excel without VBA?

Do you know Excel provides a special form, a built-in feature, for data entry? Let's find out.

Dynamically create UserForm controls and Save data in SQL Server database

In this tutorial, I’ll show you how to create and add ActiveX Controls dynamically in a UserForm and save all the data (extracted from the controls) in an SQL Server table.

How to use ternary operator within the map() function - JavaScript

The ternary operator in JavaScript is a conditional operator. It is used as an alternative to if...else statement. But do you know you can use the ternary operator within the .map() function. Yes you can and I'll show you how.

SQL Server DATENAME() Function - Get the name of distinct Months in words from a date column

I have shared fews examples in this article showing how to get distinct months, in words, from a date column using DATENAME() function in SQL Server. The DATENAME() is an SQL Server built-in function that returns a specified part (a datepart) of a specified date.

Web Scraping using Pure JavaScript - Two different methods

Web scraping (or known as Screen Scraping) is process of extracting data like HTML codes etc. from websites or web pages. The extracted data is often used for analysis or to simply display the extracted contents on other web pages. Here in this article I am going to show you two different web scraping methods using pure JavaScript.

What is Nullish coalescing operator "??" and how to use it effectively in JavaScript?

Nullish coalescing operator ?? is a logical operator that returns right-hand side value (operand) if left-hand side value (operand) is "null" or "undefined". Let's understand this operator with two simple examples.

How to get sum of array elements without using loops or recursion?

One of the easiest way to get the sum of array values without looping is to use the .reduce() method. The method reduces array elements into a single value. Most importantly, it reduces the size of the script, since you don't need to loop through each element or do any recursion.

How to Extract text within parentheses in Excel using RegEx and VBA?

In this article, I am going to show you how to use RegEx (regular expressions) in Excel to extract text within parentheses using a custom regular expression function in VBA.