PDF to Excel Converter
Templates VBA

PDF to Excel Converter in Excel VBA

In this article, you will learn how to create a PDF to Excel converter using Excel VBA. We have created a Setting worksheet wherein we are taking 2 folders inputs on range E11 and E12 respectively. PDF Files Folder: Wherein all the PDF files are available Excel File Folder: Wherein Excel files will be saved after conversion. [caption id="attachment_15980" align="aligncenter" width="658"] Setting Sheet[/caption]   Add the Microsoft Scripting Runtime Reference
Calendar
Templates

Fully Functional Dynamic Calendar Control in VBA

This Fully Functional Dynamic Calendar Control in VBA, we have designed to use in VBA project. You can use it for Excel Cells, Textbox, Label and Command Button etc. It is very easy to call this Calendar for your VBA Project. You can call this with two method. Just move this calendar form in your VBA project just drag it using mouse [caption id="attachment_12621" align="aligncenter" width="542"] Move Calendar to your
Quality Check List
Templates

Quality Check List in Excel

The template of Quality Check list has been designed to use for quality team.It can be use for other purposes also. Here we have taken the drop-down as Pass/Fail. You can use it as Yes/No, Pending/Completed ect. This template can we used for multiple purposes. It automatically change the text with Icons on the base of conditional formatting. There is no VBA code has been used. Pass/Fail drop down in
Word to PDF Converter
Templates VBA

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 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 >
Excel to PDF Converter
Templates VBA

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 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
Templates

Dynamic Calendar in Excel

This calendar template is fully dynamic. If you will change the month or year in the drop down calendar will be change automatically. To creating the month and year drop down Form Control combo box has been used. It has been created purely in Excel with the help of formulas and conditional formatting. No VBA has been used. [caption id="attachment_2434" align="aligncenter" width="641"] Dynamic Calendar in Excel[/caption] Click to download Dynamic
Data Consolidation Macro
Templates

Data Consolidation from multiple files in Excel

This template has been designed for consolidating the data from multiple excel file into a single file. This is very time saving template and can make your work very easy. There are two worksheet available in template file, one is "Logs" and second is "Consolidated_Data". Logs worksheet: In this worksheet on Column A you will see the File Names from which you have consolidated the data and on column B
Templates

Data Entry Form in Excel

This data entry form has been designed in VBA. You can enter the EMP ID, EMP Name, Gender, Designation and Salary. Since Excel sheet is protected so data can not be changed manually. [caption id="attachment_2413" align="aligncenter" width="546"] Data Entry Form Output[/caption] There are three buttons available in this worksheet. 1.Add New Record By using this button a record can be added on the worksheet. Below given form will be opened
Templates

Bow and Arrow Game in Excel

Bow and Arrow Game has been designed in Excel with help of VBA. Few images have been taken form pixabay.com. In this game you have to shoot the apple which is dropping from the tree with the help of 10 arrows. There is a speed drop down available with the Low, Medium and High option. You can the apple dropping and arrow speed by changing this drop down. [caption id="attachment_2401"
Attendance Tracker
Templates

Attendance Tracker in Excel

Attendance tracker or Attendance sheet is essential to any organization. This Attendance tracker is designed for keep one month data. In this attendance tracker, Employee Name, Supervisor, Present count, Absent Count, Leave Count, unplanned%, Planned % and dates for particular month field are available. [caption id="attachment_2395" align="aligncenter" width="640"] Attendance Tracker in Excel[/caption] Emp Name and Supervisor name to be entered manually. Present Count, Absent Count, Leave Count, unplanned% and  Planned