View Single Post
 
Old 06-23-2014, 11:01 AM
chrisd2000 chrisd2000 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jun 2014
Posts: 16
chrisd2000 is on a distinguished road
Default Can a macro rename Excel files based on a cellname?

Can a macro rename Excel files based on a cell's contents? The problem maybe that I download these files en masse from a website and they all have 54-character long randomly generated filenames which I can rename by selecting all and then use the rename function to get a series of filenames like a, a(2), a(3), ... but I would rather have the files renamed based on the text that exists in cell B1 which is the title of the report. I also read somewhere that this kind of macro only works if the tabs have names like "Sheet 1"
Reply With Quote