Changing File Name

N

New Starter

Joined
Sep 3, 2010
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining several workbooks into one file 4
Return list of file names from specific directory 3
How to get link file name in vba 2
VBA HELP! MsgBox & File & Sumif ****** 5
Code to change part of a formula across worksheets 4
Querying an Excel File with a changing file name 1
VBA Sumif *********************** Help 2
define relative path from xls to xml file 1

Top