Help - saving files

[MSL]

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

 

[Ron de Bruin]

Try

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