Saving in wrong location

So it turns out (a month later ) that this doesn't actually work.

I looked it up in the help topics and here's the description it gives:

Displays the standard Save As dialog box and gets a file name from the user without actually saving any files.

I'm not exactly sure what this method is for.

So back to my original question:
What if I don't want to specify the filename and leave it up to the user? I want to point it to a specific folder, but the user can name the file as they see fit.

http://www.excelforum.com/showthread.php?t=576657

-joel