Re-naming many excel files in a folder by VBA

[ali84pk]

Hi Dear All,

Iam new user of VBA. I need some help. I have hundreds of excel files in one folder. What I want to do is, to rename all of them by there cell values of A5 & A10 & A3 of sheet2*
*(different files have different names of sheet2)

for example if one file of excel cell's contains these informations....

sheet2 (name is hotel)
A5 (EUROPEAN VVIP Rates)
A10 (All rates below are USD non commissionable)
A3 (Updated as on 06/12/2009)

then that excel file should be renamed as
"EUROPEAN VVIP Rates USD Updated as on 06/12/2009"

Note: in A10 i only need currency type which could be any.

I need VBA which renames all files at onces

thanks in advance.

[mrice]

You'll find code to extract all the file names in a folder on my home page. To rename, you need to use the Name ...... As .... construct.

Remember that there are some characters which are not allowed in file names so you will need to think about the format of the date that you wish to use to avoid slashes.

[ali84pk]

You'll find code to extract all the file names in a folder on my home page. To rename, you need to use the Name ...... As .... construct.

Remember that there are some characters which are not allowed in file names so you will need to think about the format of the date that you wish to use to avoid slashes.

Thanks Mrice, your VBA codes worked in extracting all files in folder but I couldn't understand how to rename all files. Iam new user so, could you please explain me little in details. Thanks alot for your co-operations

[JeanRage]

Hi,

As indicated above, the VBA instruction is

Name OldName As NewName

HTH

[mrice]

Assuming that you have old and new file names in columns 1 & 2 respectively

Please Login or Register  to view this content.