Hi experts,
Can someone help me with a VBA Code that will loop through a predefined folder and rename all the files in a folder based on cell B2?
Will need to incorporate the CLEAN Function because of the spaces in cell B2.
I looked online for VBA scripts to do this task, but couldn't find one that serves my purpose. Any help would be greatly appreciated.
Imran
Can someone help me with a VBA Code that will loop through a predefined folder and rename all the files in a folder based on cell B2?
Will need to incorporate the CLEAN Function because of the spaces in cell B2.
I looked online for VBA scripts to do this task, but couldn't find one that serves my purpose. Any help would be greatly appreciated.
Imran