2013-12-25
VBA Hello World - Excel Macro - For Beginners
Get easy step by step guide to code a Excel Vba hello world program. It is perfect place to start Excel Programming for beginners. 1. Excel VBA "Hello World" Ma...
Category: Excel VBA Macro
Showing all 152 articles in this category.
2013-12-30
Send Mass Email from Excel VBA 1.3 - Multiple Recipients - In Outlook
How To Send Bulk Email From Outlook Using Excel? Learn the best ways on how to send email from Excel VBA to multiple recipients here. Download "Send Mass Email ...
2013-12-30
How To Insert Command Button - In Excel Sheet - Developer Tab?
1. Add Excel Command Button from Quick Access Toolbar This is Applicable for Excel 2007 and above versions. This page has quick tips to insert command button in...
2013-12-31
Removing Empty Folder is Now Easy - Get Folder List with Size
Get Folder List with VBA Dir - Remove Empty Folders To get the list of folders within a folder through VBA, it would have been nice if the command name is VBA D...
2014-01-04
How to Create a Macro in Excel 2010, 2007 & Above
What is a macro in excel? This is a fine option that can be used to learn Excel VBA Macro . When the "Record Macro" in switched ON: Manual operation done to exc...
2014-01-06
Excel VBA Timer Event - Run Macro at Specific Time - Automatic Schedule
Excel VBA Schedule Macro to Run at Specific Time Here you will learn - How to add Excel VBA Timer Event to run macro automatically at certain time & how to crea...
2014-01-11
How to Add a Calendar in Outlook? - Excel VBA Outlook Calendar
Excel VBA Outlook Calendar - Bulk Upload Tasks Easy trick on how to add a Calendar Item in Outlook from list of reminders/appointments in Excel. Manually creati...
2014-01-17
Microsoft Office - Communicator API - Verify Availability Status
Office Communicator Verify - User Status Office Communicator display list of Friends added in it along with their availability status (whether they are availabl...
2014-01-15
Excel VBA - Folder Operation - Exists, Create, Copy, Delete Directory
Excel VBA - Create, Delete, Exists, Copy, Move, Open Folder Operation Be it any operation on a system directory, like any of these: List Folder or check folder ...
2014-01-26
Different Methods to Refer Excel Sheet or Cell
Hierarchy: As a User, When we edit data in excel document manually we use keyboard or mouse pointer to traverse through different worksheets or cells. It is not...
2014-01-11
How to Insert Formula into Excel - How to Use Excel Formula in Macro
Shouldn't Have Combined these two topics into One: In this blog a Formula actually means the Worksheet Functions, that we use in excel sheets directly that begi...
2014-01-17
Reading Process List From Task Manager
How to Import application list from Task Manager to Excel? Well, this can be done with the help of the Windows API Function from the library Kernel32. Using thi...
2014-01-17
VBA Code - To extract data - From website to Excel Macro
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...
2014-01-26
Run Macro When Cell Value Changes or Range VBA
Call Macro if Cell Value Changes Learn how to create a VBA Range macro to run when any specific cell value changes. Also we don't have to explicit use any User ...
2014-01-21
Create Excel Formula On Your Own - User Defined Excel Functions (UDF)
Built-in Excel Worksheet Functions This Is What We Do When Excel Does Not Have A Formula That We Need Desperately. There are plenty of Excel Worksheet Functions...
2014-02-03
Launch List of Application - Batch Execution
Are we Using Start Up Folder Option We have option in Windows to add the list of application to be launched during a system start up. But, we do not use it ofte...
2014-02-21
Print Screen Automation - Take Screenshot, Save to File and Attach in Excel
One Click - Save Screenshot to an Image File and Attach in Excel. This topic explains some basics about creating a Print screen Automation Tool in Excel VBA Mac...
2014-02-27
Convert Excel String To Date - VBA Date Format
Convert Text To Date in Excel or Number For Excel date format conversion manual or VBA follow these 2 methods. Excel automatically converts the data types to it...
2014-03-04
Excel Convert - Number To Date - VBA Date Format
How to Change Excel Date Format? Excel date format related function are grouped in Menu-> Formula -> Date & Time Option. Using this, we can get today's date & t...
2014-03-06
Anagram Maker - Word Combination Generator Source Code
Anagram Maker - All possible Words Combination Generator Get Excel VBA code to create your own Word Combination Generator in 2 mins. Just follow these simple st...
2014-03-18
Remove Junk Characters In Text File - Excel Trim Just Not Helping
Excel Trim Not Working - Remove Unwanted Characters Is Your Excel function TRIM not able to remove non-displayable characters? A Trim function will remove only ...
2014-02-12
Excel VBA html Table import - Export Web Table to Worksheet
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...
2014-03-22
How to Add Sheets in Excel - VBA Create Worksheet - Dynamic Spreadsheet
How to Create a Worksheet in Excel? MS Office provides option to create dynamic spreadsheet in Excel during run-time. Also, users can do to other worksheet oper...
2014-03-29
VCF to Excel Converter - VBA Code to Read vCard File
How To Convert VCF To Excel? To convert contacts in VCF to Excel, You can use one of these methods. Download our vCard to Excel App Excel VBA Conversion Code - ...
2014-04-12
Excel VBA - Get RGB Color of Cell - Change Background
VBA to get Excel Cell Background Color RGB Code & Change it Hope you would like these in-depth Excel cell color formatting techniques. In Excel macro to get cel...
2014-04-24
VBA Merge Text Files - Combine Data Files Into One with Excel
How to Merge Files in Excel using VBA? Get VBA merge text files Excel macro code in this article. In our daily work routine we deal with lot of data & log files...
2014-04-25
Excel VBA - Import Data from another Workbook - 4 Easy Ways
Excel Import Data From Another Workbook - VBA Codes To pull data from an external Excel file, use on of these scenarios. Closed Excel file: Using VBA Import dat...
2014-05-01
Lock System at Scheduled Time with Excel
Work Life Balance and Time Management Schedule and Balance Work Vs Life This article explains how to Automate Locking a Windows Workstation and schedule your Te...
2014-05-06
Excel VBA - Shutdown Computer - Logoff User - Visual Basic Code
Excel VBA Shutdown Computer - Visual Basic Code Note: Save all your unsaved Documents before Testing this Code This VB6 or VBA Shutdown, Log off or Reboot the c...
2014-05-26
Safe Password Manager - Secure All Your Passwords
Trouble Remembering Too Many Login Credentials - Password Management with Encryption This article explains some techniques on how to make your own password mana...
2014-05-24
Password Protect Excel 2010 & 2007
How To Password Protect Excel & Word Documents? The Article explains how to secure a document with built in options & then a corresponding VBA Code snippet. The...
2014-06-04
Excel VBA Get Username - Windows Current User Name - File Author
VBA Username in Excel, Outlook, Word etc., Using Excel VBA you can get username who is currently logged in & active, get author name who edited the Excel workbo...
2014-06-18
Excel VBA Text To Speech - Voice Application Activation
Activate VBA Text to Speech (TTS) in Excel In this article you will learn about these topics related to TTS in Excel. Install Text to Speech (TTS - SAPI Windows...
2014-06-25
Excel VBA - FTP Transfer - Files Download Upload
Secure FTP Upload Thru Different Methods FTP automation is done to transfer data from PC or web server to a FTP file hosting service. Often this data is served ...
2014-07-05
VBA Download File from URL - using Excel Macro
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...
2014-07-10
Login to Facebook, Twitter, Google+ in IE from Excel
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...
2014-07-14
Making SORT More Simple and Faster in Excel with Advanced Options
Usual Sorting of Data or Table in Excel To Sort a Column Data in Excel, the user has to select the data range or column and then choose option “Sort & Filter”. ...
2014-07-19
How to Delete Blank Rows in Excel - Remove Empty Rows - 3 Easy Tips
1. Excel Delete Multiple Blank Rows (Built in Option) To remove blank rows in Excel, Open the worksheet & follow these menu options. Select data range that has ...
2014-07-22
VBA Code - Create Index of Worksheets - with Links to each Sheet
Index: Create List of Worksheet Names with Hyperlinks Ever came across this question !!! What is the maximum limit for number of sheets in Excel? Answer is: The...
2014-07-24
How to use Excel VBA Telnet To Autorun Commands?
Excel VBA Telnet Client for Remote Connect We use Telnet Client sessions to control or manage systems that does not have a keyboard or monitor attached to it. A...
2014-07-30
Import Mail IDs from Outlook Email to Excel
Fetch Email Addresses - Quick Install & Test Code Open MS Outlook and Select any mail in Inbox or any other Folder Open new Excel Workbook, Alt+F11, Copy Paste ...
2014-08-13
Email Extractor from Website or URL using Excel App
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...
2014-09-04
Archive Facebook Messages - JSON to Excel
Facebook Timeline - News Feeds - Wall Posts In this article, we are going to explain, How to use Facebook OpenGraph API to extract your FB data in JSON format? ...
2014-11-21
Convert CSV to Vcard File - Download Converter App
Conversion From CSV to VCF (or vCard) To convert a contacts from CSV to vCard file business contact format, use this easy tips. CSV stands for Comma Separated V...
2014-11-14
Not a Secret Anymore - What is my IP Address Location? Bulk GeoIP Lookup
GeoIP to Location Lookup Database - Find Website IP Many websites and software provide free GeoIP - IP to location lookup services. If we input an IP address to...
2014-11-22
Domain to IP - Find Website IP address from URL
URL to IP Address - Intro In Computer networking, IP address can be one of these 2 types & are represented in decimal/hexadecimal dotted format. IPv4 - 32 bit (...
2014-12-24
Mortgage Calculator - Loan EMI Scheduler - in Excel
Types of Mortgage Loan Interest Rates There are broadly two common types of interests in Mortgage Loans. In the first type, Interest is set to a Fixed rate of L...
2015-02-09
Create ListView in VBA at Runtime
Compatibility Issues working with Application in Older Version Of Office After the recent upgrades in Microsoft products, we can notice few compatibility issues...
2015-04-12
How to do VLOOKUP?
Macro for Vlookup Tutorial A Vlookup function search for ‘value’ in the first column of ‘table Range’ & returns a value from the same row. Syntax: =Vlookup (‘va...
2015-04-12
Android ICS File Viewer - Calendar file View in Exce;
.ics File Format (ICalendar) Events like meeting requests, tasks, alarms, to do list etc., are stored in Calendar application. This Calendar application could b...
2015-04-13
How to Convert Excel to Access Database?
Convert Excel to Access Database Use this simple method to learn how to create Access database from Excel spreadsheet. Programmers convert Excel to Access datab...
2015-05-11
Convert Excel To PDF - VBA Code Print Selected Area
Excel VBA Print & Save as PDF Commands This article provides code for creating PDF from Excel & Vba print macro Excel 2010 or versions less than that. Just like...
2015-05-13
Excel Instant Messenger - Microsoft Office Communicator API Library
Auto Send Instant Office Communicator Message from Excel This article explains how to send instant messages to your friends through Excel. The code in this page...
2015-06-27
Application Monitor – Manage & Terminate - Tasks Manager
Task Manager in Excel - How to use Excel to Monitor Servers or PC? There are in built application in Windows to view what applications are currently running in ...
2015-08-07
Compare Two Excel Sheets - Highlight Differences - Macro VBA Code
How to Compare Two Excel Sheets for Differences? How do you compare Excel Spreadsheets? To assure quality of a software, compare Excel files as explained below....
2015-08-12
Create Random Numbers in Excel and Google SpreadSheets
Random Numbers in Excel Formula, VBA & SpreadSheets Is it any Guessing Game? Yes. If you can predict the next number these functions can generate then, Microsof...
2015-09-04
UnLock Protected Excel Sheet - Remove Password to Unprotect
Unprotect Excel Sheet - Without Knowing Password Get VBA Macro code in this page, that will help you to generate an alternate password to un-protect Excel sheet...
2015-09-15
Lock a Folder - In Windows - Excel Folder Lock Code
How to Lock a Folder in Windows 7 or Above? Microsoft keeps on upgrading its Windows Operating System consistently to improve User experience and Security. Thes...
2015-11-05
Hide Desktop Icons of Active Windows Applications
How To Hide Desktop Icons of Active Apps? As the name suggests the Windows Operating System executes the application as different Windows. User sees the Desktop...
2015-12-07
How to Create Data Table Excel?
How To Create Excel Data Table? A Data Table generates different scenarios for your formula. You can use it to do What-if analysis. Lets first create a Excel Ta...
2015-12-21
Sudoku Excel Download - Puzzle Solver - Free Game Help
Sudoku Solver - Excel Games Puzzle Sudoku is one of the famous Math games that will test your memory capability. Here is the list of instructions about how to p...
2015-12-30
Pick Multiple Columns using Random Numbers in Excel
In one of the earlier topics we learned how to generate Random numbers in Excel & Google Spreadsheet . Now, we will see how to get values from Random Columns us...
2015-12-31
Export Email Data To Excel With Mailparser
Do you have hundreds or thousands of inbound emails in your Inbox with important data fields? Maybe your business is receiving leads or order confirmations by e...
2016-01-19
VBA Macro Import - Read XML File into Excel - 5 Easy Tips
Convert XML Files to Excel - 5 Methods to Import To Import XML data to Excel you can use any of these listed methods. VBA to import XML to Excel Quick VBA to Co...
2016-01-31
Convert Kg to Lbs - Feet To Meters, Miles - Liter to Gallon
Engineering Unit Conversion Table In Excel If you want to convert kg to lbs, meter to feet or liter to gallon -this Engineering Unit Converter Excel app can per...
2016-02-07
Non Repeating Unique Random Numbers - Fun with Excel
Non-Repeating Numbers - With Excel RND function In Excel VBA or any programming language we have built in function to generate random number. But it will genera...
2016-02-11
Universal VCF to Excel and Excel to Vcard Converter
What this VCF converter Can Do? Get this VCF to Excel Universal converter, to perform the below listed operations. Convert any VCF file to Excel with no limitat...
2016-05-03
Learn How To Code JavaScript in VBA
JavaScript Functions With in VBA: The Merger Include a reference to ‘Microsoft Script Control 1.0’ as explained below, before proceeding with further JavaScript...
2016-04-06
VBA To Copy Visible Cells Only and Paste in Excel
Excel VBA To Select & Copy Visible Cells In Excel, sometimes few rows wont be in visible state, when auto-filter is enabled or made hidden by any user. In such ...
2016-08-13
Send Email from Excel with Attachment using vba
How to Automate Emails From Excel? Get macro to send email from Excel & email Excel file as attachment using VBA. In this page, you will learn and get code for ...
2016-08-18
How to Get stock prices in Excel? – Best Live Stock Ticker
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 ...
2016-08-26
Convert a Formatted Cell in Excel into HTML Tag using VBA
Convert Formatted Cell in Excel to HTML To get the font and formatting style of a text in worksheet follow these methods. Excel Worksheet Cell format – Single F...
2016-09-15
Excel VBA Check - IF String Contains - Only Letters
Check IF VBA String Contains Letters or Alphanumeric There is no string operator or function that performs VBA check if string contains only letters. There is w...
2016-09-16
VBA to Create Email List using Excel - Distribution List
VBA to Add Semicolon to Email Addresses in Excel If you have Email Ids in Excel, then create distribution list using this app or VBA code. We come across situat...
2016-10-21
Convert VBA Declare Compatible with 64 Bit Office
Convert Excel VBA 32 Bit to 64 Bit To solve Compile error: 'The code in this project must be updated for use on 64-bit systems', continue reading If you upgrade...
2016-10-25
Find My PC Screen Resolution in Excel using VBA & Javascript
What is Display Resolution? The number of Pixels displayed in your Monitor is called Screen Resolution. It is represented as how many Pixels displayed in Screen...
2016-10-26
get Excel VBA Shell Command Output within Macro
Call Excel VBA Shell Command Object Output There are 2 methods to read Excel vba shell command output. Write the vba shell command prompt output to a text file ...
2016-11-01
How to create Drop down data validation list in Excel?
1. Add Drop down list with Excel Data validation? A data validation list in Excel enable users to choose only predefined values from a drop down option. If user...
2016-11-10
Excel Vba RGB to Hex,Long - Hex to Rgb,Long - Color Code Conversions
Convert VBA Color Codes to RGB or HEX To convert the Excel vba color index list to RGB, HEX, Long/Decimal use these functions. This covers almost all type of Co...
2016-11-12
Excel VBA Color Index List - Worksheet Interior Font - Colour Codes
Excel VBA Color Index List Excel color index are used to change either a worksheet's background(Interior), font or border color. There are 56 colors that has pr...
2017-01-05
Compare Two Columns Excel - Highlight Match – Bulk Data Duplicates
Excel Compare Two Columns & Report Differences Learn how to compare multiple columns in Excel with huge volume of data. Find duplicate entry in 2 columns using ...
2017-01-27
Hyperlinks In Excel– Add Remove Links Formula – Get VBA Code
How To Add Hyperlinks in Excel Using Formula? Higher version of MS Excel like 2007 or above have built in function to add links. Select a cell to insert a hyper...
2017-02-09
Excel VBA Create New Workbook - With Name - Copy Save Close
Create a New Workbook with VBA Quick trick with Outlook, Word,Excel VBA create new workbook while run-time on the go. Note: To create a Excel file from Outlook ...
2017-04-17
Copy Excel Chart in Powerpoint - Macro VBA pastespecial
How to Copy Excel Chart in PowerPoint Slides using VBA Macro - Step by Step Tutorial Requirement: We need to copy several charts from Excel in Powerpoint slides...
2017-10-10
VBA XML Parser - Read XML Nodes & Import To Excel
Read XML using Excel VBA XML is the file format that is widely used to transfer data over internet or between 2 systems with different platforms. The most widel...
2017-10-24
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. T...
2017-11-10
Open Text File - Read Write File Operations - VBA, Python, VBS, C, C++, DOS
File Operations - VBA, Python, VBS, C, C++ & DOS It is important for any programming language to open text file or get data from external file or write to a ext...
2017-12-06
Convert 2D Arary To 1D or List - Excel VBA Macro - Quickest Method
Convert Array of 2 Dimension to 1 Dimension In Excel VBA , we use 2D arrays quite often. This is because, we convert Excel Worksheet Range to Array and do the d...
2017-12-06
Excel VBA Sort Range - Columns Ascending - or Alphabetically
Excel VBA sorting Range of multiple Columns How to Sort a Excel range of data? Do it either thru VBA Sort Range code or Built-in menu option. I have presented b...
2017-12-06
How To - Connect Excel To Access - Database Using VBA
How to Connect Access Database in Excel Macros? Updating Excel Spreadsheet from Access Database using this step by step Excel VBA Access Macro code is just that...
2017-12-08
Build Excel Organization Chart - Hierarchy Tree - From Data
How to Create Organization chart in Excel? Do you want to do add Org Chart thru this menu option? Click on Excel Menu -> Insert -> Smart Art. Choose Hierarchy c...
2017-12-15
How to Disable Images in Firefox, Chrome, IE?
1. Disable Images in Firefox, IE & Chrome Speed up browsing by Turning off images in Firefox & other browsers. Yes it is also called as Text only mode. Note: Se...
2017-12-10
JSON Parser - Convert JSON To CSV - Excel VBA Macro
Parse JSON - Converter in Excel This name often reminds me of the film Jason Bourne . But this JSON is a file format standard. In this page, You can get JSON co...
2017-12-11
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 inv...
2017-12-14
Excel VBA - Copy Workbook - Active or External
Excel VBA - Copy Active Workbook Get syntax for vba function to copy active workbook or external workbook saved in the folder. For both these purpose, we will b...
2017-12-15
VBScript Extract Data - Xmlhttp Web Scrape - Parse HTML
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...
2017-12-21
VBA Macro to - Delete Shapes in Excel - Workbook Objects Boxes
Delete all Shapes in Excel Workbook In Excel a shape object can be: A square box, round, call outs, star, arrow, line etc., Do you want to clear all these shape...
2017-12-26
VBA Macro - Choose Outlook Email Account - To Send Mass Mail
Choose From Multiple Outlook Email Accounts Marketing people send tons of emails daily, to their customer base. If a customer is not interested in the offer, th...
2018-01-07
Convert Excel to HTML Table Tags - VBA Macro Code
Excel to HTML Table Do you want to copy the Excel Table to a webpage? Most of the time, It is easy to represent data in table format. Excel spreadsheet is the o...
2018-01-20
How to Run Macro - by Clicking Hyperlink - in Excel?
How to Assign a Macro - to a hyperlink in Excel? Did you just thought a button click or keyboard shortcut - are the only possible way. Run macro using hyperlink...
2018-03-30
Excel VBA - Loop Through All Open Workbooks - Get Names
VBA Code To Access All Open Excel Files The code below will loop through all workbooks that are open in current system. If you want to scan through all the open...
2018-04-06
Excel VBA - Find String in Range - Return Row - Change Background Color - Remove Duplicates
Excel VBA Find String - In Range of Cells Get code to perform search operation for a string in Excel worksheet cell range. Commands Used: Range.Find & Range.Fin...
2018-09-26
VBA to Delete File in a Folder
VBA Delete File from Computer Folder There should be multiple ways to do it. In this article, I have given 2 methods . One is by using Filesystemobject & other ...
2018-10-04
VBA Option Explicit Not Working - Solved
Option Explicit - Not Working - Fix Yes. It is very strange that my client reported that Excel app I delivered gave "Variable not defined" error. But, when I op...
2018-10-04
Convert Number to String in Excel VBA Macro Code
Number to String Conversion When we say converting a "number to string", it is not about changing a number 1 to 'One'. If you are looking for such conversion, i...
2018-10-05
How To Speed Up Excel VBA Macro Execution Time - Optimize?
Excel VBA Optimized - Reduce Run Time You can use this code in almost all of your macro code. This will improvise your code run time drastically. Macro that run...
2018-11-30
VBA File Open Dialog Box
Browse File Dialog in Excel VBA In Excel file, if you are doing any folder operations or trying to read content from another text,xlsx, csv file. It is better t...
2019-02-01
Enable Cut/Copy/Insert/Delete Options in Excel Right Click
Enable Grayed Option on Excel Right Click Does some of the options on the right click command bar is disabled or grayed out in your Excel Worksheets. Though it ...
2019-04-19
Disable Autofilter Excel VBA - Filter Switch On OFF
1. Check if AutoFilter is On or Off in any Worksheet This below vba function returns True if autofilter is enabled in a worksheet. otherwise returns false. Note...
2019-06-25
How To Sort by Color in Excel?
Excel VBA & Menu Option - Sort By Color Excel has option to Sort a column based on these 4 items. Sort based on Value Sort based on Cell color or Background col...
2019-06-25
List all Network Adapter, MAC , Enable Disable Connection using VBA
List all Network Adapters using Excel VBA Excel VBA code in this page can list all the network adapters in your computer along with its complete attributes. Net...
2019-06-26
How to get Computer MAC Address using Excel VBA?
Find MAC Address using VBA A MAC address is a unique ID assigned to a Network adapter & it stand for Media Access Control Address. There can be more than MAC ad...
2019-06-27
How to Web Scrape with VBA using IE & Parse HTML?
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...
2019-06-28
Excel VBA Remove Duplicates Values
Excel VBA - Remove Duplicates from Data Range To remove duplicate values from a data range or column, this VBA code is going to use the build in option 'Removed...
2019-07-10
How to do Spell Check in Excel?
What happens with spell check? First the spell check process will happen on current cell. The process will take each word in the cell for correct spelling. If a...
2019-07-15
Vba Get Computer Name using environment variable
Find Computer Name in Excel VBA In this page, get three different vba code to get Computer name. Environment variable Windows Api wScript.Network To get the com...
2019-07-16
Hyperlinks Index - Get all links with address, cell - Whole Workbook
Get list of all Hyperlinks in Excel file This macro produces a hyperlink index sheet. To get list of hyperlinks in each worksheet, the Vba code in this page fol...
2019-07-17
Excel VBA Delete all #N/A
VBA code to delete all #N/A error in Excel #N/A error can occur as a return code from any Excel formula like Vlookup, Lookup etc., If you copy paste data only f...
2019-07-27
How to comment - Block of multiple lines of code - in Vba?
Comment Block & Uncomment Block In VBA to comment a multiple lines of code with single step: There is no keyboard short available commenting. But VBA editor has...
2019-07-28
Rearrange Excel Sheets in Custom or Alphabetic Order with VBA
Custom Order or Alphabetical Order This page has VBA code that can arrange worksheets in a Excel file in: Custom Order as per user preference Alphabetic Order o...
2019-12-04
Excel VBA Dictionary Datatype - Create & Add Keys, Items
Excel VBA Scripting.Dictionary "Dictionary" is a datatype similar to an array, but in addition it can hold a group of variable or objects. Another available dat...
2019-08-21
Vba Check if Sheet Exists - If not Create
VBA Code to Check if Sheet with Name exists? This Excel vba code will check if sheet with a specific name exists in the workbook. As per Microsoft specification...
2019-09-23
Clear Excel VBA Immediate Window - Macro Code
Clear Excel VBA Immediate Window Manually There is no explicit option to clear immediate window. Just select all content in Immediate window using control + A, ...
2019-11-12
Merge Multiple Excel Files to One - Selected Sheets
How to Combine Sheets from Multiple Excel to One? This flexible Excel app in this page will merge Worksheets from multiple Excel files to one file. The User get...
2019-11-22
Excel VBA Rename File - without opening the File
How to Rename a file with Excel VBA? To rename a file with VBA, use the function mentioned below. Usually, You can find a lot of function used in VBA under the ...
2019-11-22
VBA Wait Time - Pause Code Execution for Few Seconds
How to Make VBA to Wait for Few Seconds? Sometimes You have to make code execution to halt (vba wait time) for few minutes. This happens when VBA code has depen...
2019-11-28
VBA - Find My Documents, Desktop & System Folder Path
VBA Code to Find My Documents Folder Path This code will get the folder path directly pointing to the 'Documents" folder. Using this code, the documents folder ...
2020-01-01
VBA get Path to Default Temporary folder
VBA - Find Temporary Folder Path To save any intermediate data files, instead of creating a folder, You can use system default temporary folders. This way, ther...
2019-12-11
How to Unzip file using VBA - Excel Macro?
Extract Zip - Unzip files with VBA To extract Zip file content, You can use windows default "Compressed (Zipped) Folder" application. There is no inbuilt object...
2019-12-12
Find Local IP Address - VBA Macro Code
Computer IP Address - Local & Public IP stand for Internet Protocol address. It is assigned to every network device - be in a computer, smartphone, router etc.,...
2019-12-12
How to Zip File or Folder using VBA Code - Excel Macro?
VBA Code to Zip File or Folder Just like this vba code, this also uses the Windows default file compressor. There is only one difference between this code and U...
2020-01-02
Validate Email Address - VBA Code - Excel
Verify Email Address Format in VBA Code in this page will verify if a email id is in proper format. This code uses regex pattern matching. To do this, first You...
2020-01-14
How to find your VBA Version - V6 or V7?
How to find Your VBA Version? The below code will get the VBA version detail using pre-compiler directives. We cannot display the value in thee variables. But i...
2020-01-21
Convert Excel to Jpg Image - VBA Code
Export Excel Range to Image (jpg/png/gif) using Vba? This code ill convert the data in Excel workbook into a jpg image file as how it is displayed on screen. Th...
2020-01-21
Excel VBA change selection in Dropdown
[VBA] Change Selection - Update Drop Down List in Excel This does not require any special code. It can be done just by changing the value in the particular cell...
2020-01-30
VBA Copy File to Folder
Excel VBA Macro to Copy File This page explains about 2 options to do file copy using Vba. CopyFile option from FileSystemObject VBA.Filecopy The first one has ...
2020-02-01
VBA Msgbox with Yes No Cancel Options
User Input Msgbox with Yes No Cancel Some time the VBA code has to get approval from user with Yes/No/Cancel optop. Here is the simple code snippet that get the...
2020-02-03
Excel VBA Delete Folder if Exists
Delete Folder using Excel VBA Macro This Excel VBA code will get folder path as input, check if it exists. Then it will delete if it exists. Important Note: Do ...
2020-02-14
Add Excel VBA Drop Down Data Validation List
How to add Data validation drop down list in Excel VBA? Two different methods to create drop down list are explained here - but all are related to validation li...
2020-02-21
Remove Drop Down data validation list from Excel & VBA
How to Remove DropDown box in Excel & VBA? If you know the cell address that you are going to delete, then it is easy. But there are times, where we might want ...
2020-05-02
Hide Unhide Worksheet Tabs in Excel
How to hide/Unhide Sheet Tabs in Excel? By default Excel displays the tabs at left hand side bottom. Using this Users can navigate to any worksheet present in t...
2020-05-02
VBA Message Box Set No as Default Button
How to Set No or Cancel as default Msgbox button? In Msgbox with YesNo or OkCancel buttons, the first button will be set as default button. i.e., once the messa...
2020-08-25
Excel Sheet Protection Check
Detect Sheet Protection Whenever working with a worksheet ever wondered why some menu buttons are not working or ribbon icons are greyed out and no functionalit...
2020-10-30
SUM and Average of Top N Values in Excel
In today's world, the data sets we have is huge and we can have so many criteria to be followed on the data For Example: Sum Average etc. Let us say we have N p...
2021-08-21
How to open VBA in Excel - Macro code editor?
How to open VBA code or Macro code in an Excel file? You will be able to open VBA (Visual Basic for Applications) code written within a Excel file using any of ...
2021-09-01
VBA to Change File Encoding ANSI to UTF8 - Text to Unicode
How to change Text encoding from ANSI to UTF8? If there are multiple txt files or programatically you need to change the encoding of a file from ANSI to UTF8 or...
2021-09-01
Excel VBA Selenium Chrome - with Sample Code
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...
2021-10-08
Run Macro from Another Workbook - Excel VBA
How to run a macro from another workbook? It is possible to run a macro present in a workbook to be execued from another workbook. To do this, we need the follo...
2021-11-16
VBA Combo box Add Items - from Excel Range or Array
VBA - Userform Combobox In userform, we can have a combobox to display list of items as dropdown. User will be able to choose one of the items from this list. T...
2021-11-21
VBA - Find number of Dimensions in an Array
Find how many dimensions an Array has? We use array to store multiple values under same variable name. This array can be a simple one dimensional array or multi...
2022-04-01
VBA Get Numbers with in a String
Get all Digits or Numbers within a String If you want to extract all the digits present in alphanueric string like "alpha123how23its98done", use this function. ...
2022-04-17
VBA Unhide all Sheets in Excel or with their Name - VeryHidden Worksheets
How to unhide all sheets in Excel using VBA code? To unhide all sheets in Excel, if you would like to set it manually, then refer to the image at end of this pa...