PDA

View Full Version : Code to save to a sub folder?



speedy dave
04-02-2010, 11:25 PM
Okay, so I have set the default save folder to be the same as where the originating spreadsheet is located......



ActiveWorkbook.SaveAs ActiveWorkbook.Path & "\" & "rent_" & Format(Date, "yyyy-mm-dd")


I am sure that i should be able to define a "Sub folder" to save the file into ( so it is not in the .Path folder), but I just can't figure it out.

Anyone ??

Bob Phillips
04-03-2010, 02:29 AM
ActiveWorkbook.SaveAs ActiveWorkbook.Path & "\mySubfolder\" & "rent_" & Format(Date, "yyyy-mm-dd")