Similar Posts

Excel Files and Sheets Data Consolidation
Excel Files and Sheets Consolidator is an MS Excel based data consolidation tool which can be used to consolidate data from multiple Excel Files or Excel Sheets. The tool supports multiple configurations such as Sheet Name, Sheet Index, Header Row and Non-Blank column to help consolidating accurate data.

Excel VBA Tips you Must Know – Part 1
Here we are coming with one more exciting post which can help you to solve very basic but very important problems while writing VBA codes.

Efficient Work Allocation in Excel: A Practical Guide
Table of Content Introduction Create a Detailed Work Allocation Template Define Case Types, Users and Status Configure Dropdowns in the Template Allocate Tasks Based on Skillsets Track Progress with Pivot Table Implement Conditional Formatting Regularly…

File Properties Tool
File Properties Tool is an MS Excel based tool which helps you to get File Name, File Path, Date Created, Date Last Accessed, Date Last Modified, Size (MB) and File Type properties of the files. You just need to browse the folder where your files are and click on ‘Get File Properties’ button.

VBA Code to Add New Sheet at Beginning or End of Excel File
VBA Code To Add New Sheet 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…

Dummy Data Generator Tool
Table of Content How does testing help? How should I test my tool or application? How does Dummy Data Generator tool helps in testing? How do I use this tool? From many years I have…

Excel Files and Sheets Data Consolidation
Excel Files and Sheets Consolidator is an MS Excel based data consolidation tool which can be used to consolidate data from multiple Excel Files or Excel Sheets. The tool supports multiple configurations such as Sheet Name, Sheet Index, Header Row and Non-Blank column to help consolidating accurate data.

Excel VBA Tips you Must Know – Part 1
Here we are coming with one more exciting post which can help you to solve very basic but very important problems while writing VBA codes.

Efficient Work Allocation in Excel: A Practical Guide
Table of Content Introduction Create a Detailed Work Allocation Template Define Case Types, Users and Status Configure Dropdowns in the Template Allocate Tasks Based on Skillsets Track Progress with Pivot Table Implement Conditional Formatting Regularly…

File Properties Tool
File Properties Tool is an MS Excel based tool which helps you to get File Name, File Path, Date Created, Date Last Accessed, Date Last Modified, Size (MB) and File Type properties of the files. You just need to browse the folder where your files are and click on ‘Get File Properties’ button.

VBA Code to Add New Sheet at Beginning or End of Excel File
VBA Code To Add New Sheet 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…

Dummy Data Generator Tool
Table of Content How does testing help? How should I test my tool or application? How does Dummy Data Generator tool helps in testing? How do I use this tool? From many years I have…

Excel Files and Sheets Data Consolidation
Excel Files and Sheets Consolidator is an MS Excel based data consolidation tool which can be used to consolidate data from multiple Excel Files or Excel Sheets. The tool supports multiple configurations such as Sheet Name, Sheet Index, Header Row and Non-Blank column to help consolidating accurate data.

Excel VBA Tips you Must Know – Part 1
Here we are coming with one more exciting post which can help you to solve very basic but very important problems while writing VBA codes.

Efficient Work Allocation in Excel: A Practical Guide
Table of Content Introduction Create a Detailed Work Allocation Template Define Case Types, Users and Status Configure Dropdowns in the Template Allocate Tasks Based on Skillsets Track Progress with Pivot Table Implement Conditional Formatting Regularly…

File Properties Tool
File Properties Tool is an MS Excel based tool which helps you to get File Name, File Path, Date Created, Date Last Accessed, Date Last Modified, Size (MB) and File Type properties of the files. You just need to browse the folder where your files are and click on ‘Get File Properties’ button.

VBA Code to Add New Sheet at Beginning or End of Excel File
VBA Code To Add New Sheet 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…

Dummy Data Generator Tool
Table of Content How does testing help? How should I test my tool or application? How does Dummy Data Generator tool helps in testing? How do I use this tool? From many years I have…
Hi
I downloaded the File Rename Tool and it did not run.
Asking fo the password to unprotect the sheet.
Please help.
Thanks,
Hi Trong,
Thanks for highlighting the issue.
We have now removed the password from the sheet. Please download the latest copy of the tool from below URL:
https://excelsirji.com/wp-content/uploads/2019/05/File-Rename-Tool.zip
Thanks,
Your Excel mate
ITS NOT GETTING DOWNLOADED
I have fixed the issue. Please let me know if you still see the issue.
How I delete Macro.
Thank you for reaching out. You may press ALT+F11 or right click on Sheet Name/Tab Name> Then click View Code, you will see a visual editor Window where you will see all the listed modules which you may simply remove to delete macros. Please let us know if you have any questions.
After clicking on ‘browse folders’ button, it gives me this error:
“Cannot run the macro “File Rename Tool.xlsm’!PickAFolder’. The macro may not be available in this workbook or all macros may be disabled.
I have checked and all my macros are enabled in excel.
You need to enable the macro or save it on Desktop to run the same.