Probems putting folders into other folders based on user input.

Hello everyone. I recently developed some script which will produce a series of folders based on a user inputing a date that it is enetered in a message box using the dd-mmm-yyyy format. The date that is entered is always the last day of a quarter. So for example it will be one of the following:

i. March 31
ii. June 30
iii. September 30
iv. December 31

Now what I have are four folders labeled

1. 1 Quarter
2. 2 Quarter
3. 3 Quarter
4. 4 Quarter

And here is where I am stuck If the user enters a date of say 30-Jun-2010 as you can see form the code below it will produce the following:

A. a folder labeled 30-Jun-2010...and some subfolders
B. a folder labeled 31-May-2010...and some subfolders
C. a folder labeled 30-Apr-2010...and some subfolders

Now what I cannot fogure out is how to take A,B and C and place them into the 2 Quarter folder. Similairyl if a user enters the date of 31-Mar-2010 then the folders that are created by the script need to be put into the 1 Quarter folder...and so on. Any help is appreciated.

Please Login or Register  to view this content.

The folders already exist.

i did that and it tells me I have a "type mismatch. see the code below

Please Login or Register  to view this content.

We are close, now it tells me that "those folder already existed"

According to the intermediate window there is an error here:

Case Month(fDate)

with an "expected expression"

It does not crash. It simply tells me the folders already exist when in fact they do not. Any other suggestions?