Save As File Name from Cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Granger - 18 Oct 2006 13:26 GMT

Is there any way of automatically generating a (Save As) file name from the
contents of a cell?

Jeff

Reply to this Message

Jon von der Heyden - 18 Oct 2006 13:37 GMT

Hi,

Yes you can, as example, the VBA would be:

Sub Macro1()
ActiveWorkbook.SaveAs Filename:="C:\" &
Sheets("Sheet1").Range("A1").Value & ".xls"
End Sub

Signature

Two heads are better than one!

Email: subst1tut3 numb3rs for l3tt3rs...

> Is there any way of automatically generating a (Save As) file name from the
> contents of a cell?
>
> Jeff

Reply to this Message

Jeff Granger - 18 Oct 2006 13:43 GMT

Thanks Jon

> Hi,
>
[quoted text clipped - 10 lines]
>>
>> Jeff

Reply to this Message