You can use VBA to prompt the user to enter a filename for an Excel spreadsheet and then save the file where the user has indicated.

I'm working on an Excel spreadsheet and so far I made it so that when you open it in Excel, a username/password form comes up and you type your info in. Now I want to save it someplace so the next ...