This Method worked.

Regards and Thanks.

Francis.

"Jim Thomlinson" wrote:

mkDir "C:\Datefile\" & format(sheets("MainPage").range("C22").Value, _
"yyyy-mm-dd")

Off the top of my head that should be close.
--
HTH...

Jim Thomlinson


"Francis Brown" wrote:

Hello.

How to you create a directory named the same as a date stored in a cell.

say sheet MainPage has a date 25/10/2005 in cell C22.

How do you take this and make a Direcotry 22-10-2005 in C:/Datefile folder.

Thanks in advance.

Francis.