Re: [ExcelVBA] Rename Files in Folders to Include Folder Names

 

You haven't said whether the renaming is a one-off task or will need to be
done on a continuing basis.

For editing of file names within directories, I use "Oscar's Renamer" which
give me an editor screen for working on all the file names in a directory
like any "other" text file. It has search/replace and simply makes the task
easier when you need to do all the files in a directory.

If it's a continuing task, then a programmatic solution would be
appropriate. For a one-off task, it will almost certainly be quicker to do
it manually, and this program can make the job easier. A Google search will
get you numerous download locations.

Regards, Dave S

----- Original Message -----
From: "sspatriots" <sspatriots@yahoo.com>
To: <ExcelVBA@yahoogroups.com>
Sent: Saturday, March 31, 2012 9:29 AM
Subject: [ExcelVBA] Rename Files in Folders to Include Folder Names

> Hi,
>
> I'm not certain on how this can be done, but I'm trying to come up with
> some code that will rename all the files in several subfolders. I need the
> new file names to include the folder name and part of the original file
> name.
>
> For example:
>
> I have folders named by tool numbers, a thread designation and a torque
> value, e.g. 0001-0832-5.5INLB. Inside these folders are some test results
> that are automatically generated by some software from a torque analyzer.
> Those file names are something like "QuickTest2 3-30-2012 9-59-40 AM.xls".
> Somehow, I need the folder information and the date information in each of
> the file names. I can lose the "QuickTest2" part.
>
> If I can get this far, then I'll need code to import the data from all
> these files along with their new file names so that I have a single
> workbook that gives me Tool Numbers, Thread Designations, Torque Values,
> Dates, etc...
>
>
> Thanks,
>
> Steve
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search
> the ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1424 / Virus Database: 2113/4905 - Release Date: 03/30/12
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___