I would like to be able to save a workbook using a macro, that will save the file in a particular loaction e.g. C:\My Documents\Spreadsheet Files\Example Spreadsheet.xls and have the directory created for those users for whom it does not exist.

I would also like the file to be named according to the contents of cell c2 on a sheet named "list"

Any help would be much appreciatted.