Can anyone here tweek this macro for renaming Excel files based on a cell's contents?

charlesdh · #5 06-28-2014, 11:26 AM

Hi,

I re-tested your code. I changed this

Code:

StrNewfullfilename = ThisWorkbook.Sheets(1).Range("B1").Value & "." & strExtension'''

Back to your original code

Code:

StrNewfullfilename = wb.Sheets(1).Range("B1").Value & "." & strExtension

When I ran the code if made the first change and then a prompt came up asking for the next "Name".
In the book created it has in column A the old file name.
And in column B the new file name.
It looped through all of the files in the "Selected" folder.

Note: It does not do what you indicated in your last post. It does as you indicated in the first question.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can a macro rename Excel files based on a cellname?	chrisd2000	Excel Programming	1	06-23-2014 06:50 PM
Excel 2007, highlight entire row based on data found in one cell	MSofficeBLUE	Excel	2	10-15-2013 09:51 PM
Image Renaming Macro?	jammer	PowerPoint	5	07-15-2013 09:21 AM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
Macro based on cell value	ubns	Excel Programming	1	05-07-2012 04:03 AM