software

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: www.excelforum.com/member.php...foamp;userid=4700
View this thread: www.excelforum.com/showthread...hreadid=505987
activeworkbook.saveas filename:=range(quot;F15quot;).value

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Chris Watsonquot; gt;
wrote in message
news:Chris.Watson.22camm_1138443001.5138@excelforu m-nospam.com...
gt;
gt; I need to save a work book into a location with a name from a cell using
gt; a macro ie: C:\Temp\Invoice\F15.
gt; F15 containing the file name.
gt; Is this possible.
gt;
gt;
gt; --
gt; Chris Watson
gt; ------------------------------------------------------------------------
gt; Chris Watson's Profile:
www.excelforum.com/member.php...foamp;userid=4700
gt; View this thread: www.excelforum.com/showthread...hreadid=505987
gt;
Sub Macro2()
Dim s, ss As String
s = Cells(1, 1).Value
ss = quot;C:\quot; amp; s
ActiveWorkbook.SaveAs Filename:=ss, FileFormat:=xlNormal, Password _
:=quot;quot;, WriteResPassword:=quot;quot;, ReadOnlyRecommended:=False,
CreateBackup:= _
False
End Sub

--
Gary''s Studentquot;Chris Watsonquot; wrote:

gt;
gt; I need to save a work book into a location with a name from a cell using
gt; a macro ie: C:\Temp\Invoice\F15.
gt; F15 containing the file name.
gt; Is this possible.
gt;
gt;
gt; --
gt; Chris Watson
gt; ------------------------------------------------------------------------
gt; Chris Watson's Profile: www.excelforum.com/member.php...foamp;userid=4700
gt; View this thread: www.excelforum.com/showthread...hreadid=505987
gt;
gt;