Sorry, the file names are automatically created every time the torque analyzer is run. The tool number and thread designation determine which folder the file will be dropped into. So, short answer is I would have to rename the files every time I use the collector workbook to bring in all the data from the individual workbook spreadsheets containing the data.
--- In ExcelVBA@yahoogroups.com, "David Smart" <smartware.consulting@...> wrote:
>
> 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@...>
> 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
> >
>
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
----------------------------------
Tidak ada komentar:
Posting Komentar