I am working on a Macro to open all .xlsx files in a specific folder and rename a worksheet on each file. Below is the Macro that I am working on, but the Macro isn't finding the folder name Part C D Repeater Section-6.
Any Suggestions
Sub RenameTab_Revised()
Dim ws As Worksheet
strPath =...