[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

__._,_.___

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

Messages in this topic (1)

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

.

__,_._,___