Dynamically Rename Files Using VBA

J

Jazz_Lounge

Joined
Dec 12, 2012
Messages
1
Reaction score
1
Hi,

I have a folder of files that have the the following characters that I want to remove.

For e.g "Abcd_(0,0,0)_efghi.log"

How could I rename the files using vba such that I would get

"ABcd_efghi.log"

Any help will be greatly appreciated! :)
 

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

Find cells that contain text 5
Rename files with VBA 8
Copy/Paste and remove blanks VBA 0
Visual Basic (Word) doesn't recognize "My" as in My.Application.FileSystem.RenameFile 2
VBA codes for zipping files and sending mails 2
Excel 2011 Mac - Import Worksheets into a Single File 0
Macro to rename Excel files in a folder 3
Trying to rename files in a folder from VBA 5

Top