Home » Forums » Open Source Learning Center » Question and Answer

Hi Vishesh need your help on naming conventions.

Submitted by bunty_1244 on 12 December, 2011 - 22:36

Hi Vishesh,

I need VBA code to perform a check for naming conventions of about 100 excel files. It includes following tasks.

1. Asks for a path for an excel file which has about 100 file names in it, open it.

2. Ask to browse a folder which has 100 files in it. Compare each file name from that excel file in to a this folder.

3. If match doesn't found (Should be a strict match) it should create a list or highlight that files in to excel file.

I hope I am clear. I have many files that was created and named specifically as per the names given in excel sheet and wants to check the naming convention of each file that saved in a folder.

Please help me. Really Appreciate your help.

Thanks & Regards,

Bunty

‹ Sequential Checker Pattern Help! Lotus Mail from VBA (How to choose from which user id to send mail?) ›
»

you can try this to display

Submitted by Anonymous on 13 December, 2011 - 15:56.

you can try this to display the file names:
http://excelexperts.com/VBA-Tips-List-Files-In-A-Folder

then use a MATCH formula to do the comparison.

»
Vishesh's picture

Hi Bunty, The solution to

Submitted by Vishesh on 13 December, 2011 - 15:15.

Hi Bunty,

The solution to your problem is a bit involved; suggest you to go through
http://excelexperts.com/contact

»

Hi

Submitted by bunty_1244 on 13 December, 2011 - 23:25.

Let me be more specific ...

Point no3 : If VBA does not find a file which is listed on excel file then it should list these missing files .. so that i can quickly find and re work on them ...

»