title: Changing the default save as location in excel without saving the workbook
body: <p>I have a workbook which I am creating from another sheet to check whether a calibration is necessary on an instrument. If the calibration is not necessary then the calibration test sheet doesn't need to be saved and ideally should not be.</p>
  
  <p>If the calibration is necessary then I need to save the calibration sheet to a specific folder.</p>
  
  <p>What I want is a script that sets the saveas location so if the user wants to save the file then it will open in the correct location, allowing manual control of saving, perhaps 10 or 20 minutes later (eg triggered by the usual File>save As method). This means I DO NOT want to save within the macro. Sorry if this was not initially clear.</p>
  
  <p>I can't find any function to do this, <code>Application.DefaultFilePath = savelocation</code> doesn't work because I am opening an existing template so the default location is always the existing one.</p>
  
  <p>I have run ChDir within my workbook and then gone to file>save as and it changes nothing, it still opens the folder where the current (master) file is saved. <code>Application.GetSaveAsFileName()</code> is no use to me because I know where it is saved and where I want to save it, I just don't want to have to navigate there and risk saving to the wrong folder.</p>