I am trying to set up a macro that looks in the contents of a cell, for
example E9, and determines the file path and file name to save the file. E9
will contain a date. Based on the date, the macro will need to select the
correct folder:

Cell E9 = 8/9/07
File path & name = C:\2007\(08) August\MCBS 08-09-2007.xls

Any suggestions?

I appreciate it.
Adam