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

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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Paul Bond" <Paul Bond@discussions.microsoft.com> wrote in message
news:FDE5AE7A-31F9-4270-ACEC-F621392C894B@microsoft.com...
> I am trying to run a macro to save a file but want to obtain the filename
> from the contents of a specific cell

i think bob has an inadvertent typo in is code

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

--


Gary


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:e%23jG54THGHA.1676@TK2MSFTNGP09.phx.gbl...
> Activeworkbook.Saves fileName:= Range("A1").Value
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Paul Bond" <Paul Bond@discussions.microsoft.com> wrote in message
> news:FDE5AE7A-31F9-4270-ACEC-F621392C894B@microsoft.com...
>> I am trying to run a macro to save a file but want to obtain the filename
>> from the contents of a specific cell
>
>