As always i come back to a solved thread. Instead of invoking the saveas screen can excel just write to the file and stamp the date and time the file was saved on to the filename?. I came across a loophole where a user could hit cancel and the file might not be saved. . The location of the file to be saved is a folder in desktop.