VBA Code to List Files in Folder
To work on multiples files through VBA programming, you need to have VBA code which can list files in a folder. Here is a simple code for you, this function list files in a folder...
VBA Code to Check if File Exist in Folder
To ensure that your VBA project works smoothly without any error, you need to put lot of error handlers and validations. Here is one of them, below code can be used to check if the given path is valid or not. You just need to provide the path of the file to the function and it will check if the file exist at the location. If it returns True that means the file is available at the path, if it returns False that means it is invalid path or the file does not exist at the location.
VBA Code to Add New Sheet at Beginning or End of Excel File
In VBA, it is sometime important to add a worksheet at the right place in the Excel. Here is a simple an effective code that adds a new worksheet at the end of Excel file…
VBA Code to Get Logged in User Name
This Excel VBA Code helps to Get User Name. Here is an example environ(username) or Application.username.This macro gets the username from active directory.
VBA Code to Delete All Shapes from Excel Sheet
Here is a VBA code which deletes all the shapes from an Excel sheet. Code is simple but you have to be bit careful while using this code as it deletes all the Shapes, Smart…
VBA Code to Convert Excel Range into HTML Table
This Excel VBA Code converts the excel range into HTML and also can convert Excel to HTML Table to paste data on Outlook Email Body
Custom Calendar Control for MS Access
MS Access by default provides inbuilt functionality to pick dates using calendar control; however it lacks few basic functionalities which makes selecting a date bit difficult. For example, if you want to select a date…
How to Add Outlook Reference in Excel VBA
To automate Outlook based tasks from Excel you need to add Outlook Object Library (Microsoft Outlook XX.X Object Library) in Excel References. You can follow below steps to add Outlook reference in Excel VBA: 1….
VBA Code to Export Access Recordset to Excel
Creating a VBA tool in MS Access is always better as compare to MS Excel. MS Access provides better user interface and ability to handle multiple users. Still people prefer to pull and see the…
How to Create dropdown List in Excel
Watch Excel Tutorial Video - How To Create Dropdown List In Excel Excel is an awesome Microsoft utility which most of the professionals are using for their day to day office use as Excel is...
Create Dynamic Data Validation List – Offset Function Method
Watch Excel Tutorial Video - Create Dynamic Data Validation List – Offset Function Method When I started my career in working with excel dashboards, I always used to face most common challenge in “Data Validation”...
VBA Code to Send Outlook Emails
Sending bulk emails is very common activity, there are many office activities which needs a person to send bulk emails to a single or multiple recipients. You also may require to add attachments in the…
VBA Code to Draft Outlook Emails
Have you ever felt the need of an Excel based VBA tool or code which can help you to draft Outlook emails in bulk by reading recipients and other details from Excel? Here is very…
VBA Code to Read Outlook Emails
Reading emails from Outlook and capture them in Excel file is very common activity being performed in office environment. Doing this activity manually every time is quite boring and time consuming. Here is a VBA…
VBA Code to Browse a Folder
Quite often a VBA developer requires code to browse a folder. This is mainly for saving the output file or reading the input file(s). Below is the VBA code that can be used to browse…
VBA Code to Browse an Outlook Folder
Outlook is most commonly used emailing application used in the world. Many people spend their entire day on Outlook application to read and response to emails. To automate certain rule based tasks in Outlook, we…
VBA Code to Count Color Cells with Conditional Formatting
Have you ever got into situation in office where you need to count the cells with specific color in conditional formatted Excel sheet? If yes then you can use following code which counts the number…
VBA Code to Browse a File
There are few VBA codes which are commonly used by every developer. One of them is giving an option to user to browse a file. Below is a sample code where I have given a browse button…
How to Count Color Cells in Excel- Step by Step Tutorial
Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells...