BLOG
EXCEL TRICKS

TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?

You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use this amazing excel formula to remove these spaces: Excel Formula: =Trim(text)   Below is an …

Read More
FREE VBA UTILITIES
3

Excel VBA Tool to Create Folders

In VBA, you can use MkDir function to create folders in your system or shared drive. To make your work simple, we bring a free Excel VBA tool to create folders. To use this tool, enter Base folder path where you want to create folders and the name of the …

Read More
VBA TRICKS

VBA Code to Re-link MS Access Link Tables

In MS Access, the best way to create a multiuser tool is to divide your solution. One part acts as interface and other one acts as database. You can have multiple copies of the interface distributed to users which are connected to central MS Access database saved at common shared …

Read More
VBA TRICKS
1

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 on Excel sheet. Note that if there are sub-folders available in the folder then this …

Read More
VBA TRICKS
1

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 …

Read More
VBA TRICKS

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 Worksheets.Add After:=Worksheets(Worksheets.Count)   If you want to add the new worksheet at the beginning of …

Read More
VBA TRICKS

VBA Code to Get Logged in User Name

Sometimes in VBA projects, a programmer is required to control the access on the data or sheets. This can be achieved using two ways: 1. Design a login userform and display it on the open event of the workbook. Based on the credentials, you can access the control on the …

Read More
VBA TRICKS

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 Shapes, Charts, Pictures, Objects and Equations from the sheet ‘Following function deletes all the Shapes, …

Read More
VBA TRICKS
1

VBA Code to Convert Excel Range into HTML Table

As a VBA developer you may frequently come cross with a requirement of sending an email through Outlook along with an HTML table inside email body. Adding an HTML table in email body is very simple task if you do manually, just copy the range in Excel and paste it …

Read More
FREE VBA UTILITIES

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 from year 2015 then you need to navigate multiple times to select correct date since …

Read More
VBA TRICKS

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. From the Menu Bar, click on Tools > References… 2. Select ‘Microsoft Outlook XX.X Object …

Read More

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn