Rename part of the file name in a folder

I need help, i want a windows script, maybe  a notepad to be saved with .vbs or .bat that can do the following

prompt me to choose the desired folder and once i chose folder then ask me the string to find in file names in this specified folder and once found that string as part of the file names then another inputbox to ask me what do i want to replace is with.

for example, i have many files in a folder with name   Product1 - Copy.doc and Product34 - Copy.doc and so on, i want to replace all of the "- Copy" part with " Original"

any help is appreciated.

i also can accept the Excel VBA if can do what i have explained above.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Anne TroyEast Coast ManagerCommented:
The very first utility at the link is AWESOME.

Get all the file names into the Excel file, find/replace, then run the macro to change the names.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bill PrewIT / Software Engineering ConsultantCommented:
No need to invent a script for this, there are far too many freeware utilities to allow mass renaming.  Here are a  few in my toolbox, I am sure one or more will work for you:

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VB Script

From novice to tech pro — start learning today.