I'm sure this is a very simple one for most people! I'm trying to run a save as from code, but has a variable filename and to a variable directory so needs user input.

I have set the ChDir to the root directory and used the GetSaveAsFilename application to open the save as dialogue box. This opens up the Save As box, to the correct directory, with the filename in the correct box. However, when I hit save, the box closes, sub ends as planned but the file has not been saved.

Any ideas?
Cheers
A

ChDrive ("S")
Private Sub SaveAs_Control_Sheet()

ChDir ("S:\CLIENTS")
MsgBox "Select the folder in which to save the new control Sheet", , "Control Sheet Setup"
Application.GetSaveAsFilename

End Sub