I need to save a work book into a location with a name from a cell using
a macro ie: C:\Temp\Invoice\F15.
F15 containing the file name.
Is this possible.


--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile: http://www.excelforum.com/member.php...fo&userid=4700
View this thread: http://www.excelforum.com/showthread...hreadid=505987

activeworkbook.saveas filename:=range("F15").value

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Chris Watson"
wrote in message
news:Chris.Watson.22camm_1138443001.5138@excelforu m-nospam.com...

I need to save a work book into a location with a name from a cell using
a macro ie: C:\Temp\Invoice\F15.
F15 containing the file name.
Is this possible.


--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile:
http://www.excelforum.com/member.php...fo&userid=4700
View this thread: http://www.excelforum.com/showthread...hreadid=505987

Sub Macro2()
Dim s, ss As String
s = Cells(1, 1).Value
ss = "C:\" & s
ActiveWorkbook.SaveAs Filename:=ss, FileFormat:=xlNormal, Password _
:="", WriteResPassword:="", ReadOnlyRecommended:=False,
CreateBackup:= _
False
End Sub

--
Gary''s Student


"Chris Watson" wrote:


I need to save a work book into a location with a name from a cell using
a macro ie: C:\Temp\Invoice\F15.
F15 containing the file name.
Is this possible.


--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile: http://www.excelforum.com/member.php...fo&userid=4700
View this thread: http://www.excelforum.com/showthread...hreadid=505987