Bulk File Rename

[gholsted]

I need to rename many file names to match existing names in our record system. For example, new file is "10W511-803-R1.pdf" and existing file is "SHF-10W511-803^161730106.pdf". Need to rename new to existing.

[Greg M]

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[gholsted]

After a little discovery on my part, it works perfectly! How can I change the "H:\Results Files" to use the current folder (wherever that may be)? Much appreciated.

[LJMetzger]

Hi and welcome to ExcelForum,

How can I change the "H:\Results Files" to use the current folder

Please Login or Register  to view this content.

Lewis

[gholsted]

Works perfectly - thanks to you both for your support.