Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename Batch of Files in VBA
I'm using Excel 2000.
I have a big macro to create - I don't expect the group to do all my work, information on how to get started would be good for now. My goal: I have a directory ("C:\My Documents\Archive") which contains multiple subdirectories, each of which contains files to be renamed. Some subdirectories also have their own subfolders. Those files whose name starts with the string "File" needs that string replaced with the folder name. If the file does not start with the string "File", the immediate folder name gets added to the start of the folder name. The filelist will include non-Excel files. I can do the string replacing bit, it's the creating a list of folders and their content files, and then getting the immediate folder and using that to rename the files that I have no idea about, and Google isn't helping much :) Thank in advance. Darren |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I batch convert 97-2003 .xls files to 2007 .xlsx files | Excel Discussion (Misc queries) | |||
Batch conversion of XP files to 97 files | Excel Discussion (Misc queries) | |||
Can I batch rename new worksheets | New Users to Excel | |||
Batch Files | Excel Programming | |||
Batch files and VBA | Excel Programming |