Renaming doc/docx Files with Excel Data

jts_01

New Member
Joined
Jul 28, 2011
Messages
1
I'm new here and I'm hoping that someone would be kind enough to help out with a dilemma that I've been wrestling with for the past few hours. I would be EXTREMELY greatful :)

Here it goes:
I am trying to rename a couple hundred doc and docx scientific abstract files which were collected from an online submission form. I have a tab delimited "readme" file which which includes the submiter's first and last name, file name, and the type of abstract submitted. There are up to 4 types of abstracts that can be submitted which are listed in a column as well. They include the following:

-"Abstract Upload (for Oral presentation):"
-"Poster Abstract Upload:"
-"Poster Abstract Upload 2:"
-"Poster Abstract Upload 3:"
*w/o quotes
*many individuals submit more than one type

What I would like to accomplish is renaming the existing files to the following: "lastname"_"firstname"_"abstracttype"."doc or docx"

*I will rename the above four types to just oral, post, post2,post3.

I have found some vba scripts which function by replacing the existing file name for another defined file name. I'm not sure if I should be looking for a way to create the desired file type in a new column first then run such a script or is there a script that can do everything in one step? I'm really a newbie when it comes to this kind of thing.

Any help would be greatly appreciated.

The following illustrates what I want:
Name: "Test, Joe,"
Type: "Poster Abstract Upload:"
Original File Name: "Raw Abstract.doc"
Final File Name: "test_joe_poster.doc"

The tab delimited file is structured as such and includes the quotes:
"test,joe" / Abstract Upload (for Oral presentation): / Oral Abstract.doc
"test2, joe2" / Poster Abstract Upload 2: / Poster Abstract 2.docx
and so on....

/ = new column
 
Last edited:

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,224,503
Messages
6,179,134
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top