You can set a fixed folder, as in the example above, or have the user pick a folder using the FileDialog object (or the GetSaveAsFilename function, but then the user will be able to change the suggested filename, so less safe).
What i need is to have this formula automatically change the value week1 to week2 and so on. › ▲ Vba Auto Increment File Name Changer ▲
