View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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