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

 

Hi,

Update. I've found Ron De bruin's Merge data macros that bring in the whole file path into a single spreadsheet along with the data I needed from each workbook. I tweaked it a little and got it to bring the data into the workbook that has the code in it rather than let it create a seperate workbook with all the data. If anyone wants to see it, I'll post it or send it to them.

Thanks,

Steve

--- In ExcelVBA@yahoogroups.com, "sspatriots" <sspatriots@...> wrote:
>
> I know I could do this with DOS commands, but I'm trying to figure out a way to do everything with an Excel workbook. Data and new spreadsheets are being created every day. Ideally, once done and the data from a workbook is collected in the collector tool, I want my code to delete the workbook.
>
> --- In ExcelVBA@yahoogroups.com, Dr John C Bullas <john.bullas@> wrote:
> >
> > I think DOS commands can grab folder names
> >
> > http://www.msfn.org/board/topic/56320-retrieve-current-directory-name-in-batch/
> >
> > Any good?
> >
> > Dr B
> >
> > On 30 March 2012 23:29, sspatriots <sspatriots@> wrote:
> > > 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
> > >
> > >
> > >
> >
> >
> >
> > --
> > ===========================
> > http://uk.linkedin.com/in/drjohnbullas
> >
>

__._,_.___

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

Messages in this topic (6)

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

.

__,_._,___