saveas ActiveWorkbook.SaveAs Filename:=Range("A1").Value
Thanks Ryan.
--
If this post helps click Yes
---------------
Jacob Skaria
"ryguy7272" wrote:
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
|