how do i obtain a file name from a cell contents and use it to sa.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Bond - 19 Jan 2006 21:14 GMT

I am trying to run a macro to save a file but want to obtain the filename
from the contents of a specific cell

Reply to this Message

Bob Phillips - 19 Jan 2006 21:19 GMT

Activeworkbook.Saves fileName:= Range("A1").Value

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> I am trying to run a macro to save a file but want to obtain the filename
> from the contents of a specific cell

Reply to this Message

Gary Keramidas - 19 Jan 2006 22:03 GMT

i think bob has an inadvertent typo in is code

ActiveWorkbook.SaveAs Filename:=Range("A1").Value

Signature

Gary

> Activeworkbook.Saves fileName:= Range("A1").Value
>
>> I am trying to run a macro to save a file but want to obtain the filename
>> from the contents of a specific cell

Reply to this Message