Save As to a specified location

[King_08]

Hello,

I am looking to save a file with the file name and the date yesterday to a specified location. I was able to come up with this by searching a few threads.

ActiveWorkbook.SaveAs Filename:= "myfile " & format(range("V1"),"mmddyy")

My concern is, what would be the code to specify where the file is going to be saved? and where will I inject that to the code above? Many thanks in advance!

 

[Airfix9]

You wish to define the location? If so, how about:

const strPath as string = "C:\My First Folder\My Second Folder\"

ActiveWorkbook.SaveAs Filename:= strPath & "myfile " & format(range("V1"),"mmddyy") & ".xlsx"

Edit to suit.

 

[King_08]

Thanks a lot. Got it working