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
Blogs
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
Rating Meter Chart in Excel
Rating Meter Chart in Excel is very innovative and informative chart to show the Process or Portfolio level health in five buckets – Worst, Bed, Average, Good and Best. This
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"
Stylish Butterfly Chart – Version 2
This is the version-2 of Stylish Butterfly Chart. In the “Stylish Butterfly Chart – Version 1”, we created it vertically. In this chart we will create the butterfly chart horizontally.
Stylish Butterfly Chart – Version 1
We are back with one more interesting chart that is Stylish Butterfly Chart (Version-1). This is useful for the comparison of two team on different KPIs. You can use this
Informative KPI Indicator Chart Version-2
This is the 2nd version of Informative KPI Indicator Chart. In this chart I have used a RAG color pallet in 10 slices (10% each). Here I have taken Service