Create folder structure based on values in Cells

[Traymond]

I'll try to explain as best i can so as not to be confusing. i have a macro that will currently save my workbook file and give it a name based on the value in a cell. In my current macro i have the folder i want the workbook file copied to typed in. Here is the next level i need to go with the macro. i want the macro to automatically create the folders i need based on the value it finds in certain cells. The base folder i work out from is C:\Quotes

Example: i would need the macro to create the folder structure based on the values it finds in the following cells . start with A1 and finish with A3.

Note: ( in the attached file the cells are different i just used these cells to basically show how it needs to work.)

A1 = acme products
A2 = 2011
A3 = 5-Jan

i would need to the macro to create the following folder structure.. and copy my workbook file into the 5-Jan folder.

C:\Quotes\acme products\2011\5-Jan

keep in mind C:Quotes already exists and always will. the macro just needs to create the acme products\2011\5-Jan folders off of C:\Quotes

it will need to do error checking to see if the folders(s) already exist etc...

i attached a sample workbook file with my current macro so you can see the code i am using right now. I'll answer any questions that need be ... Thanks ,

[JBeaucaire]

Like so:

Please Login or Register  to view this content.

This is based on the code published here:

Make Folders and Subfolders

[Traymond]

This looks like what i need ....

[Traymond]

It works perfectly !!!!!! Thanks