Holtzman | main NewSpring namespace and utilities for all newspring | State Container library

I have an Excel file with hundreds of Customer names and several article numbers. What I want to achieve is to have a macro that checks if a folder exists with selected customer name and create a new folder if it is missing. Once the customer folder is found or created, macro should check if there is a folder for each article number and if it is missing, create a new one. I found a code that seems to do all that and more posted by Scott Holtzman, but since my reputation is too low to comment, I can't ask explanation in that topic.

I have referenced Microsoft Scripting Runtime as the code requests, but both of the "If not" statements are marked red and the pop-up window only says "Compile error". I have checked the syntax of "If not" statements and it seems to be correct but since I'm not experienced in VBA I can't be certain. Is there something more I should activate somewhere for this to work?