In this article you will learn how to rename the multiple files available in a folder. In the previous post I have explained you how we can get the files information in a excel sheet. We will use the same method to get the current file names of given folder. Once we have the file names in the excel sheet then we will give new name in another excel column
In this article you will learn how to get the files information from a folder like File Name, File Type, File size, Last modify date etc. in excel sheet. We will use the file system object to create this. To use the file system object you need to add “Microsoft Scripting Runtime” Reference. To add this Reference go to Visual basic editor > Tools > References > Microsoft Scripting Runtime
In the previous article you have learnt how to Excel to PDF converter using VBA. In this article you will learn how to convert multiple Word files into PDF file using VBA. This is quite useful and easy macro. We have used File System Object method here. To use the file system object you need to add “Microsoft Scripting Runtime” Reference. To add this Reference go to Visual basic editor >
In this article you will learn how to convert multiple Excel files into PDF file using VBA. This is quite useful and easy macro. We have used File System Object method here. To use the file system object you need to add “Microsoft Scripting Runtime” Reference. To add this Reference go to Visual basic editor > Tools > References > Microsoft Scripting Runtime [caption id="attachment_7149" align="aligncenter" width="459"] Add Reference[/caption] We
This time we have developed an innovative and stunning Digital Clock in Excel. We have created this using Excel auto shapes and VBA. Click here to download this Excel workbook. Watch the step by step video tutorial:
Creating the Chart on a VBA user form is quite interesting. We have created 4 KPI Charts – Battery Chart, Speedometer Chart, Moving Man Chart and Progress Circle Chart on a User form which is fully dynamic. KPI value is connected with a Textbox. As soon as the text box value will be changed chart will show the updated number. We have also given the Change chart type drop-down. KPI
In this article you will learn how to use a web browser in the user form. You can search anything or open a website using the text box. [caption id="attachment_7077" align="aligncenter" width="1310"] Web Browser in User form[/caption] Below are the steps to create the web browser in the user form- Go to the Visual basic editor (Press Alt+F11) Open the Toolbox. [caption id="attachment_7069" align="aligncenter" width="604"] Open the Toolbox[/caption]
While creating the data entry form in VBA, we need to put several validations. One of them is dependent drop-down. In this article you will learn how to create multilevel dependent drop-down in VBA user form. To create the dependent drop-down list, we have to create the data in Excel sheet as given in below image. [caption id="attachment_7034" align="aligncenter" width="773"] Data for dependent drop-down[/caption] Below is the VBA
While create the Data Entry form in VBA, We need to put some validation in text boxes and combo boxes. In this article you will how we can put the validation for Mobile Number entry. Below is the user form wherein we have created a text box to input the Mobile number. [caption id="attachment_6942" align="aligncenter" width="364"] User form[/caption] After submitting, the mobile number will be added to the worksheet. [caption
Here we have created a beautiful and dynamic Project Plan (Gantt chart) in Excel. We have given a drop-down to change the weekly and daily view. There are 3 type of status has been given Pending, Completed and In-Progress. We have used VBA to change the View daily to weekly and visa-versa. This is password protect worksheet. The password is “1234” Below is the Weekly View- [caption id="attachment_4053" align="aligncenter" width="1183"]
