ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   saveas ActiveWorkbook.SaveAs Filename:=Range("A1").Value (https://www.excelbanter.com/excel-programming/427095-saveas-activeworkbook-saveas-filename-%3Drange-a1-value.html)

DarrenL

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

Jacob Skaria

saveas ActiveWorkbook.SaveAs Filename:=Range("A1").Value
 
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


Jacob Skaria

saveas ActiveWorkbook.SaveAs Filename:=Range("A1").Value
 
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


ryguy7272

saveas ActiveWorkbook.SaveAs Filename:=Range("A1").Value
 
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


Jacob Skaria

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



All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com