Quick Excel Macro for FilePath Reset

I'm in urgent need of an Excel macro to bulk update and reset certain parts of a file path to links in my .xlsx (Excel Workbook) files. The parts of the file path that require modification includes the file name, folder name and also the drive letter. The macro should be able to identify the relevant parts of the file path using case sensitivity.

Ideal Skills and Experience:
• Proficiency in Excel Macros and VBA
• Ability to implement case-sensitive text operations
• Experience with file operations in EXCEL, especially with .xlsx files

Job Description:
• Create an Excel macro for .xlsx files
• The macro must reset file name, folder name and drive letter of file paths
• Use case sensitivity to identify necessary changes
• Complete task efficiently and swiftly

Please only bid if you have the ability to complete this task promptly. If you've completed similar tasks, kindly reference them in your bid. Your efficiency is much appreciated. Thanks.