VBA to rename files?

Hello,

Is it possible to batch rename files through Excel?
I have several folders each containing 38 files. ie 1.obj, 2.obj, 3.obj....... through 38.obj
I need to have each file given a unique name

ie
1.obj renamed to V_GBH.obj
2.obj renamed to B_GGHC.obj
3.obj renamed to V_DFV.obj

Is it possible to have a setup such that
the file the name in A:1, will be renamed to B:1
the file the name in A:2, will be renamed to B:2

etc

My directory path:
D:\SVD_Tests\3D_Scenes\Characters\3D_Models\Export_Tests\Folder_01

Thanks for any help

Jeff

This can be done through Excel/VBA.

You will need a code module and a macro that scans the file names.

The macro will look like this

Please Login or Register  to view this content.

Cool

Thanks, Dennis7849!

Jeff