Changing File Name

New Starter New Starter is offline

New Member

Join Date: Sep 2010

Posts: 1

3rd Sep 2010

Hi Guys,

I am new to VBA and Excel.

Suppose you have about 50 files in a folder e.g. "C:\My Documents\Forms" and names of the files are

AA1_AA1_M03 ECON Reporting.xls
AA2_AA2_M03 ECON Reporting.xls
AA3_AA3_M03 ECON Reporting.xls
AZ1_AZ1_M03 ECON Reporting.xls
CF9_BG1_M03 ECON Reporting.xls
DA1_JA5_Month_03 ECON Reporting.xls

I would like to have a macro which would reduce the name of the files to the first three letter only i.e. above names should be converted into

AA1.xls
AA2.xls
AA3.xls
AZ1.xls
CF9.xls
DA1.xls

Thanks

« Re: Check if UserForm is loaded? | Re: Is cell outside printable area? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
delete info from source file w/out changing the destination file	TB	Microsoft Excel New Users	0	26th May 2008 06:26 PM
Changing File Folder To Save File Using Office Takes >45 Sec	=?Utf-8?B?RXJpYw==?=	Windows XP Performance	6	17th Dec 2006 11:15 PM
Changing a .MOV file into a Windows Movie Maker compatible file?	=?Utf-8?B?Y2hyaXN0aW5h?=	Windows XP MovieMaker	1	21st Mar 2004 05:36 AM
File download box will not open, even after changing options in File Types window	=?Utf-8?B?TWlzdGVyIEI=?=	Windows XP Internet Explorer	1	16th Mar 2004 01:41 AM
Open delimited text file to excel without changing data in that file	zohanc	Microsoft Excel Programming	1	3rd Oct 2003 01:06 AM