Congratulations on becoming bronze, Jacob!


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Jacob Skaria" wrote:

strPath = "c:\"
ActiveWorkbook.SaveAs Filename:=strPath & Range("A1").Value

If this post helps click Yes
---------------
Jacob Skaria


"DarrenL" wrote:

I need to put a specific folder in here.
ActiveWorkbook.SaveAs Filename:=Range("A1").Value
Desktop\xxxxxxx\xxxxxxxxx range (A1)
Thanks
Darren