Renaming all FileName in an Folder using Macro at a time with Different Names

**Karthik@1305** · 09-23-2010, 12:47 AM

Hi Team,

Now iam Working in excel 2003, I got a Requirement that, After Downloading datas From SAP, It Directly Stored in Excel Sheet , Using tht Sheet1, I need to rename all the Filenames at a time, Is It possible, Any code is there to rename,

For Example,

From SAP to Excel Sheet Datas are Like this in Sheet1,

DmsNo Filename
50007685 SDFFG.jpg
50004678 HGJKID.jpg
50003421 VGFTHR.jpg

Then i have rename that filename, rename 'SDFFG.jpg' To '50007685.jpg', and it Should be directly rename to my Source File.

For Example:
Source File: C:\test\SDFFG.jpg

After renaming it Should be,

Source File: C:\test\50007685.jpg

Is it Possible?... any code is there to rename,

Regards
Karthick

**johnjohns** · 09-23-2010, 03:40 AM

You can do this in 2 steps. First, list all you directory contents into a sheet, with following codes. Thanks to John Walkenbach for this macro

Please Login or Register  to view this content.

Then select all the files and run the below macro

Please Login or Register  to view this content.

rgds

johnjohns

**johnjohns** · 09-23-2010, 04:25 AM

Sorry... To run the second macro, select only the first file name. It will stop for the first 10 files (As this cannot be undone, I kept this as a security. You can interrupt and stop the macro here, if needed). Also if you have all the files listed on a sheet, no need for the first macro.

rgds

johnjohns

**Karthik@1305** · 09-24-2010, 12:44 AM

Ok John, thank u so much, Its working Fine, Thanks a lot John,,,,,,,,

Regards
Karthick

**henanksha** · 06-26-2014, 06:14 AM

Hey,

I'm in an urgent need of an Excel macro that enables me to rename all files in a folder AND put these renamed files in a separate folder.

Can you please mail me this macro of yours on - [email protected]

Any help will be much appreciated.

Cheers

Renaming all FileName in an Folder using Macro at a time with Different Names

LinkBack

Thread Tools

Rate This Thread

Display

Renaming all FileName in an Folder using Macro at a time with Different Names

Re: Renaming all FileName in an Folder using Macro at a time with Different Names

Re: Renaming all FileName in an Folder using Macro at a time with Different Names

Re: Renaming all FileName in an Folder using Macro at a time with Different Names

Re: Renaming all FileName in an Folder using Macro at a time with Different Names

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions