In Excel, how can I define both "default file location" and "default filename" through VBA.
I do >> NOT << want to use the "Tools | Options | General" to set the default location.
Essentially, the spreadsheet (.XLT) would be used by multiple individuals... they all have to save it to the same location with the same filename (thus replacing existing files in the default subfolder).
Ideally, there would be a macro button on the worksheet (.XLT) ... once clicked the content of the .XLT would then be saved as an .XLS without them even having to specify name/location.
Is that doable? If so, how can this be done via VBA?