Excel vba code to search for multiple files
₹600-1500 INR
Paid on delivery
I want a vba enabled excel in which I want to search for multiple files. Say i input 10 different values in cell B2 to B10, now based on these cell value it should search for exact match wildcard file in a defined location(folder) and if match found then green colour should show next to these value say in C2 and so on else Red colour. Please note that, the file name something abc_12345_hello already exists in the file location. So i will just enter the value 12345 in the B2 and on clicking macro button search it will find file having wild card with exact match 12345 in the file location and if found then green colour else red. I would have almost 100-200 data at a once in col B, so it should check for the same one by one.
Project ID: #24661817
About the project
Awarded to:
Hello, Hope you are doing well. I can help you in your project About me & what I can provide - • 5+ Yrs. of Experience in EXCEL & VBA. • Knowledge of DASHBOARDS, FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS. • More
7 freelancers are bidding on average ₹1143 for this job
Hi there I will write a VBA macro to identify if the file name in folder contains the string you have in column B. Regards Reuben
Hi, from the description i understand all your data files are excel format. If so, i can meet your requirement and provide solution Let us discusss more over chat
Hi there, Hopefully you will be fine. I have read your requirement and decided to do your job. I make you sure you will get right work within time. If you are interested then we chat more. Thank you
I am interested in your project and having very good knowledge of Excel VBA and Macros. Presently working with one of the leading BPO industry as a senior Analyst.
Hello I am very much interested this project. Please confirm the Same so we can start the project asap. you can call Amit - 9819293576 THANKS
