Ok guy,  here's my question.

I would like to do this specific task in a macro:

1-  Read out the name of the drawing (file name)th std format in our shop is    XXXX-XXXXX-XXX

2-  check every items in the BOMin a particular column.(will be XXXX-XXXXX-XXX-XX

3- if XXXX-XXXXX-XXX-XX  = XXXX-XXXXX-XXX then it does nothin. If not it will change the caracter font to spot it quicker in the BOM.

4- Can also do it backward.

if you have a macro that does that partialy or completely , I would like to see how it is done.

thank you verry much

check out the PDF for a better exemple of what I need