Try

ActiveWorkbook.SaveAs Sheets("mysheet").Range("d1").Value & ".xls"

--
Regards Ron de Bruin
http://www.rondebruin.nl



"MSL" wrote in message ...
Hi

I'm trying to create a macro that automatically saves a file with a file
name taken from a cell - ie: Order number 12345

I'm sure it should be possible but I do I do it ?

Sorry if that's really basic but I'd appreciate any advice.

Thanks

Scott