Help - saving files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MSL - 28 Oct 2006 15:17 GMT

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

Reply to this Message

Ron de Bruin - 28 Oct 2006 15:34 GMT

Try

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

Signature

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

> Hi
>
[quoted text clipped - 8 lines]
>
> Scott

Reply to this Message