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