troubleshooting Question

Renaming Work books in a folder using a macro

Avatar of kamunya
kamunya asked on
Visual Basic ClassicMicrosoft Excel
4 Comments1 Solution220 ViewsLast Modified:
I'd like to rename all the Questionaires in a folder using this convention ManagerName_FundName_mmyy
ManagerName=A2 in each work book
FundName=B2 in each work book
mmyy=C2 in each work book

The macro should go to the 1st work book in folder L:Research\Questionnaires and Loop through all the workbooks renaming each one. Each work book will have macros so I would like it to automatically enable the macros as well so that the text box doesn't keep coming up.
ASKER CERTIFIED SOLUTION
dirknibleck

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros