Dave

Doing this as two separate macros seems like extra work. If you already have the code that creates the folder structure, why don't you just modify that to take the Part Numbers list (Column A of you sample doc) and do all of the rest in code?

You haven't explained the 5 or 9 digit padding well. How is the code supposed to work out whether it is padding to 5 digits or to 9?

Is the space you added in front of the folder names in your sample intentional?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia