Siddhart Nagwekar
New Member
Hi All,
I have a set of files in a few folders. Each folder signifies a different department. The files are downloaded from the company portal and are named as per the date and time. Each workbook has just one worksheet and the intended name of the each workbook is cell B2 of that respective workbook.
What I need is a macro which will first ask me for the folder containing the files, then open each workbook, copy the cell contents of cell B2, rename the workbook with that name (from cell B2) and close the file, till the last file. Right now I do this manually. The downloading of the workbooks itself is time consuming and add to that this process of renaming the files takes up a lot of time.
Any help will be appreciated.
I have a set of files in a few folders. Each folder signifies a different department. The files are downloaded from the company portal and are named as per the date and time. Each workbook has just one worksheet and the intended name of the each workbook is cell B2 of that respective workbook.
What I need is a macro which will first ask me for the folder containing the files, then open each workbook, copy the cell contents of cell B2, rename the workbook with that name (from cell B2) and close the file, till the last file. Right now I do this manually. The downloading of the workbooks itself is time consuming and add to that this process of renaming the files takes up a lot of time.
Any help will be appreciated.