excel - How to set file destination for to a certain map?

Question

I have this code and I would like to save the file in a certain map on my pc.

How could I add a custom path, so I could change it in the future when needed?

As of now it just saves on my desktop.

Code:

ThisWorkbook.SaveAs ThisWorkbook.Path & "" & Format(Now, "yyyymmdd") & " Testing"

Answer 1

This is the way:-

ThisWorkbook.SaveAs "C:Users" & Format(Now, "yyyymmdd") & " Testing.xlsx"

You can replace "C:Users" with any path. But please don't forget to add the file extension at the end.