amaresh achar
Board Regular
- Joined
- Dec 9, 2016
- Messages
- 108
- Office Version
- 365
- Platform
- Windows
Hi,
In continuation to below mentioned post, I want to modify the code (from the below post) such that, If the file has a worksheet named "Q", then it should add a suffix "_Q" to the newly generated file name.
Any help would be great... Thanks in advance.
In continuation to below mentioned post, I want to modify the code (from the below post) such that, If the file has a worksheet named "Q", then it should add a suffix "_Q" to the newly generated file name.
VBA code to rename the files in a folder as per respective file cell values.
I am looking for VBA code assistance to do the following: >> I have about 3000 files in a folder (with some random alphanumeric values as file names) >> Each file has unique values in cells B3, D7, G5 of Sheet1 >> I want a macro to rename each file with respective cell values as...
www.mrexcel.com
Any help would be great... Thanks in advance.