Rename Multiple File on one click
In this article you will learn how to Rename Multiple File files available in a folder. In the previous post I have explained you how we can get the files
Tag: VBA
File System Object: Get Files information in Excel
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
Automation: Word to PDF Converter
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
Automation: Excel to PDF Converter
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
Analog Clock in Excel (Pie Chart + Doughnut Chart)
Analog Clock in Excel (Pie Chart + Doughnut Chart) After creating the Digital Clock, we have created a beautiful Analog Clock. This stunning Analog Clock we have developed using Pie Chart
Innovation: Digital Clock in Excel
This time we have developed an innovative and stunning Digital Clock in Excel. We have created this using Excel auto shapes and VBA. Digital Clock in Excel [caption id="attachment_7136" align="aligncenter"
VBA: Dynamic Chart on User Form
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
VBA: Web browser in the User Form
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 VBA: Web
Excel Tip : Fill the blanks cells in your data
Many times we have zig-zag data which has to be formatted in proper manner to create some report or dashboard. In this article you will learn how we can Fill
VBA: Multilevel dependent drop-down in User Form
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